INSERT INTO Table2
(id, name)
VALUES (3, EncryptByPassPhrase('aspdotnetsuresh', 'yemineni'))
SELECT id, CONVERT(varchar(50), DECRYPTBYPASSPHRASE('aspdotnetsuresh', name)) AS Decryptedname
FROM Table2
Printable View
INSERT INTO Table2
(id, name)
VALUES (3, EncryptByPassPhrase('aspdotnetsuresh', 'yemineni'))
SELECT id, CONVERT(varchar(50), DECRYPTBYPASSPHRASE('aspdotnetsuresh', name)) AS Decryptedname
FROM Table2