Simple Encrypt String Function

Posted: November 21, 2011 in SQL Server 2005

You can use the following function to encrypt a string:

-- Declare variables
DECLARE @lv_pwd VARCHAR(100);

-- Initialise variables
SET @lv_pwd = 'password';

-- Encrypt the string
SELECT PWDENCRYPT(@lv_pwd) encrypt_pwd;

-- Check that the password is correct
SELECT PWDCOMPARE(@lv_pwd, PWDENCRYPT(@lv_pwd), 0) encrypt_pwd_compare;

This will return a 1 for a match and a 0 for a mismatch.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s