DecryptByPassphrase function : DecryptByPassphrase « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. DecryptByPassphrase

3> CREATE TABLE ForEncDemo (
4>     rowid int IDENTITY(1,1) PRIMARY KEY,
5>     name nvarChar(20),
6>     id_data_orig Nvarchar(11),
7>     id_data_enc varbinary(70)
8> )
9> GO
1>
2>
3> DECLARE @pp_value nvarchar(10);
4> SET @pp_value = 'passphrase';
5>
6> SELECT id_data_orig, id_data_enc AS "Encrypted data",
7>    CONVERT(nvarchar, DecryptByPassphrase(@pp_value, id_data_enc,
8>    1,
9>    CONVERT(varbinary, rowid))) AS "Decrypted data"
10> FROM ForEncDemo
11> WHERE rowid = 1;
12> GO
id_data_orig Encrypted data

                                                                                                                                Decrypted data
------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------- ------------------------------

(0 rows affected)
1> drop table ForEncDemo;
2> GO
1>