MSSQL 단방향 암호화

- MSSQL 2008

create table test (

id varchar(100),

pwd varbinary(500)

);

insert into test values ('t1',PwdEncrypt('1004'));

select PwdCompare('1004', pwd) from test;

- MSSQL 2012

create table test (

id varchar(100),

pwd varbinary(500)

);

Insert into test ( id, pwd ) Values ( 'a1', HASHBYTES('SHA2_512' , '123456') );

select * From test Where id = 'a1' AND pwd = HASHBYTES('SHA2_512' , '123456');