问加密SQL server中的现有列数据。

EN

DECLARE @FirstName VARCHAR(100) = (SELECT FirstName FROM db_table WHERE Id = 518)
DECLARE @LastName VARCHAR(100) = (SELECT LastName FROM db_table WHERE Id = 518)

OPEN SYMMETRIC KEY DemoKey  DECRYPTION BY CERTIFICATE MyCert; 

UPDATE db_table 
SET FirstName = EncryptByKey(Key_GUID('DemoKey'), @FirstName),
    LastName = EncryptByKey(Key_GUID('DemoKey'), @LastName)
WHERE Id = 518

CLOSE SYMMETRIC KEY DemoKey;