create proc proc_user_pwd ( @user varchar(100), @Pwd varchar(100), @returns int ) as if exists (select 1 from users表 where user =user and pwd =Pwd ) begin return 1 --有效 end else begin return 0 --无效 end
--修改一下create proc proc_user_pwd ( @user varchar(100), @Pwd varchar(100), @returns int ) as set returns = 0 if exists (select 1 from users表 where user =user and pwd =Pwd ) begin set returns = 1; return end else begin return end
select 1 from tablname where user = @user and pwd =@pwd
create proc proc_user_pwd
(
@user varchar(100),
@Pwd varchar(100),
@returns int
)
as
if exists (select 1 from users表 where user =user and pwd =Pwd )
begin
return 1 --有效
end
else
begin
return 0 --无效
end
--修改一下create proc proc_user_pwd
(
@user varchar(100),
@Pwd varchar(100),
@returns int
)
as
set returns = 0
if exists (select 1 from users表 where user =user and pwd =Pwd )
begin
set returns = 1;
return
end
else
begin
return
end