CREATE TABLE test ( UserId VARCHAR(25), UserPwd VARBINARY(100) ) INSERT INTO test (UserId, UserPwd)VALUES ('ssey', PWDENCRYPT('ssey9119ssss')) update test set userpwd=PWDENCRYPT('ssey9119ssss') select * from test SELECT PWDCOMPARE('ssey9119ssss', UserPwd) FROM test WHERE UserId='ssey' -- µÑÀÌ °°À¸¸é 1 (true), Ʋ¸®¸é 0 (false)¸¦ ¸®ÅÏÇÏ°Ô µÈ´Ù. -- ±×¸®°í ¿ø¹®À̳ª ¾ÏÈ£¹® µÑ Áß Çϳª°¡ NULL À̸é NULLÀ» ¸®ÅÏÇÏ°Ô µÈ´Ù. select PWDENCRYPT('9119')