encrypt-decrypt in T-SQL

Posted on 2005-05-17
Medium Priority
Last Modified: 2008-03-17
can we encrypt and decrypt values in t-SQL. for example, when outputing data can we encrypt the value of an ID field in T-SQL. Then can we use the encrypted ID and decrypt it in T-SQL to query another set of data?
Question by:vinny45
LVL 70

Expert Comment

by:Scott Pletcher
ID: 14020006
SQL provides no direct support for that.  There are undocumented procedures that use SQL Server encryption, but it is known not to be especially strong.

I recommend getting a third-party tool for encrypting/decrypting that is more robust.  I don't know if there are any free, good tools available or not.
LVL 13

Accepted Solution

ispaleny earned 2000 total points
ID: 14020461

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question