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