SQL SERVER 数据库字段简单加密解密

--------加密函数-----------
CREATE FUNCTION dbo.EncryptByPassPhrasePwd(@password nvarchar(50))
RETURNS varbinary(max)
AS
BEGIN
declare @pwd varbinary(max)
SELECT @pwd = EncryptByPassPhrase(
'bgx',
@password)
return @pwd
END
---------解密函数----------
CREATE FUNCTION dbo.DecryptByPassPhrasePwd(@password varbinary(max))
RETURNS nvarchar(max)
AS
BEGIN
declare @pwd nvarchar(max)
SELECT @pwd =CAST( DecryptByPassPhrase('bgx',@password) as nvarchar(max))
return @pwd
END
注意：www.baidu.com 是用于生成对称密钥的通行短语
select dbo.EncryptByPassPhrasePwd('test11') as result
select dbo.DecryptByPassPhrasePwd(0x01XXX) as result