Save Password in encript form.

This code snippets shows how to save password in encripted form into database:

First of all we will take the varbinary datatype for password field.

also we will convert that field in our query when we will save that like.

insert into TableName (password) values (convert(varbinary, 'Password'))

and in store procedure:

insert into TableName
(           
   Password
)
values
(               
   convert(varbinary, @Password)
);