sqlserver数据加密

---修改字段类型为varbinary
SELECT ks_xm, zjno from bk_ks where id=73623;

UPDATE bk_ks set zjno='371581200307050851' where id=73623;

UPDATE bk_ks set zjno=EncryptByPassPhrase('test',zjno) where id=73623;

SELECT ks_xm, CONVERT(varchar,DECRYPTBYPASSPHRASE('test',zjno)) from bk_ks where id=73623;

SELECT ks_xm from bk_ks where  CONVERT(varchar,DECRYPTBYPASSPHRASE('test',zjno)) LIKE '%1111111111111111111%';