MSSQL Base64 String Encode,Decode Function

 

 

 

CREATE FUNCTION [dbo].[Base64EncodeByBin] ( @PlainText VarChar(MAX) ) RETURNS VarChar(MAX) BEGIN DECLARE @ENCODED VARCHAR(MAX) SELECT @ENCODED = CAST(N'' AS XML).value('xs:base64Binary(xs:hexBinary(sql:column("bin")))','VARCHAR(MAX)') FROM ( SELECT CAST(@PlainText AS VarBinary(MAX)) AS bin ) AS bin_sql_server_temp; RETURN @ENCODED END ----------------------------------------------------------------------------------------------------------------------------------- CREATE FUNCTION [dbo].[Base64DecodeByBin] ( @EncodeText VarChar(MAX) ) RETURNS VarChar(MAX) BEGIN DECLARE @DECODED VARCHAR(MAX) SELECT @DECODED = CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:column("bin"))','VARBINARY(MAX)') AS VarChar(Max)) FROM ( SELECT CAST(@EncodeText AS VarChar(MAX)) AS bin ) AS bin_sql_server_temp; RETURN @DECODED END