• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass