Encrypt Password in SQL

Hello folks,

Today we will see how we can encrypt password before saving into database table.

There are many ways to implement this feature like defining Asymmetric keys and using that into table/sp or use some hash algo to encrypt password etc but we will add some complexity into encryption stuff.

Objective: ¬†Our goal is to generate very complex and encrypted password which can’t be hacked (not even by database guys using sql injection etc).

Solution:

Step 1: Create a table that will hold username, password and other details. See below sample. Continue reading