Base64Encode, Base64Decode 스칼라 함수

(1) Base64Encode DROP FUNCTION IF EXISTS [dbo].[Base64Encode] GO CREATE FUNCTION [dbo].[Base64Encode] ( @v_Plain VARCHAR(MAX) ) RETURNS VARCHAR(MAX) BEGIN DECLARE @v_Encoded VARCHAR(MAX) SELECT @v_Encoded = CAST(N'' AS XML).value('xs:base64Binary(xs:hexBinary(sql:column("bin")))', 'VARCHAR(MAX)') FROM ( SELECT CAST(@v_Plain AS VARBINARY(MAX)) AS bin ) AS bin_sql_server_temp; RETURN @v_Encoded EN..

원문링크 : Base64Encode, Base64Decode 스칼라 함수