CREATE FUNCTION [dbo].[f_base64_encode] (@bin varbinary(max)) returns varchar(max) as begin return cast(N'' as xml).value('xs:base64Binary(xs:hexBinary(sql:variable("@bin")))', 'varchar(max)') end GO CREATE FUNCTION [dbo].[f_base64_decode] (@64 varchar(max)) returns varbinary(max) as begin return cast(N'' as xml).value('xs:base64Binary(sql:variable("@64"))', 'varbinary(max)') end GO
宠辱不惊,看庭前花开花落;去留无意,望天上云卷云舒