This post will show you how can you encrypt/decrypt the password in SQL server 2012 fully using SQL Server store procedure.
VALUES('Girfa', 'girfa',EncryptByPassPhrase('key', '123') , 1)
Encrypt
INSERT INTO AdminMaster ( Name, UserName, Password, Status)