Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 ENCRYPTION

Author  Topic 

wided
Posting Yak Master

218 Posts

Posted - 2012-05-10 : 12:28:47
hi

how to encrypt column on table

Exemple:
I have a table

my table (col1, col2)
i need to encrypt/dencrypt col2

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-10 : 12:30:43
see

http://msdn.microsoft.com/en-us/library/ms179331(v=sql.100).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

wided
Posting Yak Master

218 Posts

Posted - 2012-05-10 : 12:37:35
thanks visakh16
but
whats 'Sales.CreditCard'
is it a table?
where i find it
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-10 : 15:53:15
thats the table. Sales is schema and CreditCard is tablename

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

wided
Posting Yak Master

218 Posts

Posted - 2012-05-14 : 04:18:43
can i have a simple exemple

i can t anderstand the code
thanks
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-05-14 : 04:36:50
Then perhaps you should give the task to someone more experienced?
At least for the moment while you practice and learn more about encryption and decryption?


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -