OPEN SYMMETRIC KEY keyName DECRYPTION BY CERTIFICATE certName; declare @as nvarchar(12)='122' select CONVERT(NVARCHAR(30), DECRYPTBYKEY(ENCRYPTBYKEY(KEY_GUID('keyName'),@as))) CLOSE SYMMETRIC KEY keyName;
对应的证书名称与密钥名称可以在sql服务器上查看