--加密:
declare @logintable table(username varchar(20),passwd varbinary(256))
insert @logintable(username,passwd) values('yourname',pwdencrypt('123456'))declare @pwd varbinary(256)select @pwd=passwd from @logintable where username='yourname'
--比较:
if pwdcompare('12356',@pwd)=1
print 'true'
else
print 'false'select * from @logintable
declare @logintable table(username varchar(20),passwd varbinary(256))
insert @logintable(username,passwd) values('yourname',pwdencrypt('123456'))declare @pwd varbinary(256)select @pwd=passwd from @logintable where username='yourname'
--比较:
if pwdcompare('12356',@pwd)=1
print 'true'
else
print 'false'select * from @logintable
Create Procedure EnCode @InStr Varchar(20)
As
Declare @OutStr Varchar(20)
Set @OutStr = ''
Declare @i int
Declare @j int
Set @i=1
while @i <= len(Rtrim(@InStr))
Begin
Set @j = ascii(SubString(@InStr,@i,1))+ len(Rtrim(@InStr))- @i
Set @OutStr = @OutStr + (Case When @j >126 then Char(@j -20) Else Char(@j) end)
Set @i=@i+1
End
Select @OutStr
As
Declare @OutStr nVarchar(20)
Set @OutStr = ''
Declare @i int
Declare @j int
Set @i=1
while @i <= len(Rtrim(@InStr))
Begin
Set @j = ascii(SubString(@InStr,@i,1))+ len(Rtrim(@InStr))- @i
Set @OutStr = @OutStr + (Case When @j >126 then Char(@j -20) Else Char(@j) end)
Set @i=@i+1
End
Select @OutStr