본문 바로가기

Programming/ASP .NET

MSSQL 2005에 필드 암호화 하기

== 암호화 하여 튜플 삽입하기 ==
INSERT INTO MEMBERSHIP values('rE', pwdencrypt('1234'))

== 암호화된 튜플 검색하기 ==
SELECT UID FROM MEMBERSHIP WHERE 1 = pwdcompare('1111', PASSWORD)
// Return one more UID or nothing

SELECT pwdcompare('1111', PASSWORD) FROM MEMBERSHIP WHERE UID = 'rE'
// Return [0 | 1]