DECLARE @Encrypt nvarchar(4000);
SELECT @Encrypt = CONVERT(nvarchar(4000),'Vithal');
SELECT HashBytes('SHA1', @Encrypt);this query helps to save column value in encrypted format
this query helps to save column value in encrypted format
DECLARE @Encrypt nvarchar(4000);
SELECT @Encrypt = CONVERT(nvarchar(4000),'Vithal');
SELECT HashBytes('SHA1', @Encrypt);