Encrypt and decrypt a field on MS SQL Server using Encryptbypassphrase and Decryptbypassphrase

In the database implementation of encryption and decryption of the article, Insus.net earlier also wrote, can be found in this blog can be searched.

Use Encryptbypassphrase and decryptbypassphrase today to make it simple.

Create a table in the database to demonstrate

 
 
CREATE TABLE [dbo].[Users]
(
    [U_nbr] NVARCHAR(20) NOT NULL PRIMARY KEY,
    [Pwd] VARBINARY(MAX)
)

When a user registers or adds a record, you can use the following SQL statement:

When you need to verify user login information, we need to decrypt the password entered by the user:

The code above is to create a stored procedure and then execute the stored procedure. If the information entered by the user is consistent with the information at the time of registration, return 1, reverse 0, and indicate that it was decrypted successfully.

Encrypt and decrypt a field on MS SQL Server using Encryptbypassphrase and Decryptbypassphrase