加密
CREATE TABLE Test
(MyStr varbinary(max) NOT NULL)
GO
INSERT Test(MyStr)
SELECT EncryptByPassPhrase(
'A1B2C3E4',
'世界和平')
SELECT MyStr FROM Test
/*
通常的查询结果：
0x01000000CCBC800C6B5CECE3F211FB975C2F8B681CC8301DDE74CF783C6A593
16C2BAC08D568151FD573E2FDE01C800805C8D1D5984727DEE95040C1FB604003
A3EFDD0444CE72D7E505D1A4
*/
解密
SELECT CAST(DecryptByPassPhrase('A1B2C3E4',MyStr) as varchar(max)) FROM Test
/*
查询结果：
世界和平
*/
