【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“444.sql”一文,供大家参考学习!
declare @User varchar(100),@Password varchar(100)
select @User='mrfdw',@Password='mrgwh'
--Insert插入
insert into dbo.tb_pwdencrypt22 (Up_Name,Up_Password)
select
@User,convert(varbinary(256),pwdencrypt(@Pass
word))
--Select
查询 Select * from tb_pwdencrypt22
where Up_Name=@User
and pwdcompare(@Password,Up_Password)=1