Welsh Corgi (7/15/2014)
One that has an example of encrypting and decrypting the same column.
You don't encrypt columns. Get that idea out of your head, it's probably causing your confusion. There is nothing special about the column. It is not flagged as encrypted, it is not a special data type or setting. It is a stock-standard varbinary column.
You encrypt data when you insert it. So as part of your insert statement.
You decrypt data when you retrieve it. So as part of your select statement.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability