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

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

4> CREATE TABLE ForEncDemo (
5>     rowid int IDENTITY(1,1) PRIMARY KEY,
6>     name nvarChar(20),
7>     id_data_orig Nvarchar(11),
8>     id_data_enc varbinary(70)
9> )
10> GO
1>
2> DECLARE @name nvarchar(20), @in_id_data nvarchar(70)
3>
4> SET @name = 'Red'
5> SET @in_id_data = '111-11-1111'
6> INSERT ForEncDemo (name, id_data_orig) VALUES(@name, @in_id_data)
7> GO

1>
2> DECLARE @pp_value nvarchar(10)
3>
4> SET @pp_value = 'passphrase'
5>
6> UPDATE ForEncDemo
7> SET id_data_enc = EncryptByPassPhrase(@pp_value, id_data_orig,
8>    1,
9>    CONVERT(varbinary, rowid))
10> WHERE rowid = 1
11> GO

1>
2> drop table ForEncDemo;
3> GO

1>