create proc login
@username varchar(20),
@pass varchar(20),
@ret int outpur
as
if exists(select 1 from 表 where username=@username)
begin
if @username=@pass
set @ret=0
else
set @ret=1
end
else
begin
set @ret=-1
end
@username varchar(20),
@pass varchar(20),
@ret int outpur
as
if exists(select 1 from 表 where username=@username)
begin
if @username=@pass
set @ret=0
else
set @ret=1
end
else
begin
set @ret=-1
end
@username varchar(20),
@pwd varchar(20),
@ret int outpur
as
if exists(select 1 from 表 where username=@username)
begin
if exists(select 1 from 表 where username=@username and pwd=@pwd)
set @ret=0
else
set @ret=1
end
else
begin
set @ret=-1
end
返回是否可以用return 来表示?