SQLServer encryption field

xiaoxiao2021-03-06  47

Create Table #a (UseName Char (10), Passwrd Varbinary (200)) - Password Field Insert #a (UseName, Passwrd) VALUES ('BB', PWDENCRYPT ('654321'))

Declare @pwd varbinary (200) SELECT @ PWD = Passwrd from #a where useename = 'bb'

IF PWDCompare ('654321', @ PWD) = 1Print 'true'lse print' false '

Select * from @logintable

转载请注明原文地址:https://www.9cbs.com/read-117469.html

New Post(0)