Example of Sql Server 2005 Symmetric Encription Using DESX algorithm

Run Below Query in Your Sql Server 2005 Query Analyzer



USE master;



--CREATE SYMMETRIC KEY SecureSymmetricKey

--        WITH ALGORITHM = DESX

--        ENCRYPTION BY PASSWORD = N'StrongPassword';



--SELECT * FROM sys.symmetric_keys;



OPEN SYMMETRIC KEY SecureSymmetricKey

    DECRYPTION BY PASSWORD = N'StrongPassword';





-- declare and set varible @str to store plaintext

DECLARE  @str NVARCHAR(100)

SET @str = N'Hello World';



-- declare and set varible @encrypted_str to store

-- ciphertext

DECLARE @encrypted_str VARBINARY(MAX)

SET @encrypted_str =

          EncryptByKey(Key_GUID('SecureSymmetricKey'), @str);





-- display ciphertext

SELECT @encrypted_str AS CipherText;



-- declare and set varible @decrypted_str to store

-- decrypted ciphertext

DECLARE @decrypted_str VARBINARY(MAX)

SET @decrypted_str = DecryptByKey(@encrypted_str);



-- display decrypted text

SELECT CONVERT(NVARCHAR(100), @decrypted_str) AS PlainText;



-- close and drop the key

CLOSE SYMMETRIC KEY SecureSymmetricKey;

--DROP SYMMETRIC KEY SecureSymmetricKey;

Powered by ScribeFire.