SQL Server/T-SQL Tutorial/System Functions/DecryptByPassphrase

DecryptByPassphrase function

   <source lang="sql">

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></source>