Post reply

how to encrypt column of a table

  • March 31, 2011 at 2:47 am

    #233946

    1) How to encrypt a column of a table in SQL2008

    2) How to select that data from that encrypted column

    3) How to match a value of that encrypted column

    For example, say the table name is table1, column name is Col1.

    We need to know how to encrypt it

    How to select from table1.col1 with encryption, and without encryption

    How to join a variable = table1.col1

    How to insert, update, delete from table1.col1

    Is there anything special method needed for restore of such databases.

  • March 31, 2011 at 5:16 am

    #1305900

    for most encryption types, youll end up changing the datatype of your column to varbinary to store the newly encrypted value. google "sql 2008 encryption for examples, as it's a big subject.

    encrypt by passphrase is the easiest to implement, and is portable between databases, as long as you know the passphrase.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply