MS SQL2000 암호화 (PwdEncrypt, PwdCompare)

MSSQL 2000 암호화 함수

 

PwdEncrypt('암호화문자')

 사용예) SELECT PwdEncrypt('1234')

 

PwdCompare('비교대상문자', PwdEncrypt('암호화문자'))

 사용예) SELECT PwdCompare('1234', PwdEncrypt('1234'))

 같으면 1, 다르면 0 을 리턴