CREATE ASYMMETRIC KEY Asym_WEB_MAIN
WITH ALGORITHM = RSA_512
ENCRYPTION BY PASSWORD = ‘password’
DECLARE @encryptedstuff NVARCHAR(100)
SELECT @encryptedstuff = EncryptByAsymKey(AsymKey_ID(‘Asym_WEB_MAIN’), N’Data to be encrypted’)
SELECT @encryptedstuff
SELECT CAST(DecryptByAsymKey(AsymKey_ID(‘Asym_WEB_MAIN’), @encryptedstuff, N’password’) AS NVARCHAR)
