sql server 加解密函数的用法

declare @pwd varbinary(max) ,@password nvarchar(1000) , @EncrptString nvarchar(max)
set @password ='1234567'

set @EncrptString= '我是中国人'
--加密
SELECT @pwd = EncryptByPassPhrase( @password, @EncrptString)
select @pwd
--解密
SELECT @EncrptString =CAST( DecryptByPassPhrase(@password,@pwd) as nvarchar(max))
select @EncrptString

/*

-- 取得主机MAC地址, **风险为不一定存在主机连接

select * from master..sysprocesses where hostname = host_name() 

*/

转载于:https://www.cnblogs.com/easybi/p/4023161.html