sqlserver加密字段

create table #a
(usename char(10),
 passwrd varbinary(200))    --密码字段
insert #a(usename,passwrd) values('bb',pwdencrypt('654321'))

declare @pwd varbinary(200)
select @pwd=passwrd from #a where usename='bb'

if pwdcompare('654321',@pwd)=1
print 'true'
else
print 'false'

select * from @logintable