[MS-SQL 2000] 패스워드 암호화하기

DROP TABLE #TEMP_MEMBER
GO

CREATE TABLE #TEMP_MEMBER (   
 User_ID    NVARCHAR(20),    
 User_PW    NVARCHAR(50),
 User_PW1    NVARCHAR(50)
)
GO

INSERT INTO #TEMP_MEMBER VALUES ('User', pwdencrypt('PW'), 'PW' )

SELECT * FROM #TEMP_MEMBER

SELECT    pwdcompare('00',User_PW), User_PW1, '00'
FROM    #TEMP_MEMBER
WHERE    User_ID = 'User'
 -- 0

SELECT    pwdcompare('PW',User_PW) , User_PW1, 'PW'
FROM    #TEMP_MEMBER
WHERE    User_ID = 'User'
-- 1

UPDATE #TEMP_MEMBER
SET User_PW = pwdencrypt('1111'), User_PW1 = '1111'
WHERE    User_ID = 'User'

SELECT * FROM #TEMP_MEMBER

SELECT    pwdcompare('PW',User_PW), User_PW1, 'PW'
FROM    #TEMP_MEMBER
WHERE    User_ID = 'User'
 -- 0

SELECT    pwdcompare('1111',User_PW), User_PW1, '1111'
FROM    #TEMP_MEMBER
WHERE    User_ID = 'User'
 -- 1