create procedur proc_logincheck ( @login_name varchar(128), @login_pwd varchar(128), @existsflag int output ) as begin set @existsflag = isnull((select 1 from bo_user_login where 1=1 and user_login_name = @login_name and user_login_pwd = @loginpwd),0) -- other login process business logic end go
create procedur proc_logincheck ( @login_name varchar(128), @login_pwd varchar(128), @existsid int output ) as begin select @existsid = isnull(max(id),0) from bo_user_login where user_login_name = @login_name and user_login_pwd = @loginpwd end 直接将结果返回,没有就是0
create procedur proc_logincheck ( @login_name varchar(128), @login_pwd varchar(128), @existsflag int output ) as begin set @existsflag = isnull((select 1 from bo_user_login where 1=1 and user_login_name = @login_name and user_login_pwd = @loginpwd),0) -- other login process business logic end go
@login_name varchar(128),
@login_pwd varchar(128),
@existsflag int output )
as begin
set @existsflag = isnull((select 1
from bo_user_login where 1=1
and user_login_name = @login_name
and user_login_pwd = @loginpwd),0)
-- other login process business logic
end
go
create procedur proc_logincheck (
@login_name varchar(128),
@login_pwd varchar(128),
@existsid int output )
as begin
select @existsid = isnull(max(id),0)
from bo_user_login where
user_login_name = @login_name
and user_login_pwd = @loginpwd
end
直接将结果返回,没有就是0
@login_name varchar(128),
@login_pwd varchar(128),
@existsflag int output )
as begin
set @existsflag = isnull((select 1
from bo_user_login where 1=1
and user_login_name = @login_name
and user_login_pwd = @loginpwd),0)
-- other login process business logic
end
go