【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了proc_Login.sql提供大家参考,希望对大家有所帮助!
use db_SMS
go
if object_id('proc_Login') is not null
drop proc proc_Login
go
create proc proc_Login
(
@UserName varchar (20),
@UserPwd varchar (20)
)
as
if exists(select * from tb_User where UserName=@UserName and UserPwd=@UserPwd)
return 100
else
return -100
go