CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Shantanu Gupta
Shantanu Gupta

Reputation: 21108

How to do Encryption and Decryption in Sql Server 2005

I want to encrypt and decrypt data with sql server using RSA or SHA algorithm rahter than doing it at UI.

Is it possible to do this.

Some Code Snippet will be a great help

Upvotes: -1

Views: 792

Answers (1)

RSK
RSK

Reputation: 17516

if u need to encrpt only a string (Can't Decrypt these are One way)

u may try

HashBytes ('<algorithm>', { @input | 'input' } )<algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1

ref : http://technet.microsoft.com/en-us/library/ms174415.aspx

Upvotes: 0

Related Questions