SQL Server-database Field encryption Problems

 

Original question:

 

Dear teacher:

 

I have a field in a table to be encrypted, for example, the salary amount and name of an employee,

these two fields need to be encrypted, let others go from Enterprise Manager the contents of the Open table are a bunch of garbled characters, but under the Program select emp_id, name, wage from employees the display is correct data, what should I do? Do you have any special skills or settings to complete?

 

Best regards

 

Answer:

 

Dear reader, thank you very much for your support for Zhang Limin's research office. If you have any questions, please reply as follows:

 

Microsoft SQL Server 2000There are no built-in functions to meet your needs. You may consider writing an encryption/decryption mechanism to encrypt data when writing data to the database. Enterprise ManagerOr, in the program mode, the data queried is encrypted. To restore the encrypted data to the original data, you only need to decrypt the data.

 

As discussed above, we can know, the algorithm used in this encryption and decryption mechanism must be reversible. Next, we will discuss what is reversible and what is irreversible encryption and decryption mechanisms. A few years ago, the media reported that Professor Wang of Shandong University cracked MD5 , it is an irreversible ( one-way ) the encryption and decryption mechanism, that is, the encrypted ciphertext, cannot be restored to the original unencrypted plaintext.

 

Common reversible algorithms include: Rot13 Because the algorithm is simple and reversible, you can find a large number of reference data on the network. As shown in the following figure SQL Server 2000Medium, free pre-stored programs for encryption and decryption:

 

Http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

 

We hope this information will help you.