我要以下@EmpId,@IsAdmin参数为输出参数
在AdoStoredProc两个参数据输送类型仅自动为pdOutPut
CREATE PROCEDURE [dbo].[CheckLogin]
@WhId varchar(50),
@LoginId varchar(50),
@Password varchar(50),
@EmpId varchar(50) output,
@IsAdmin bit out
AS
--set @EmpId='0001'
--set @IsAdmin=0
if (Not exists(select 1 from sys_user u inner join sys_whuser w on u.LoginId=w.UserId and w.WhId=@WhId and u.Password=@Password and u.Isuse=1)) and ((select IsAdmin from sys_user where LoginId=@LoginId and Password=@Password)<>1)
return 0
return 1-------------------
谢谢
在AdoStoredProc两个参数据输送类型仅自动为pdOutPut
CREATE PROCEDURE [dbo].[CheckLogin]
@WhId varchar(50),
@LoginId varchar(50),
@Password varchar(50),
@EmpId varchar(50) output,
@IsAdmin bit out
AS
--set @EmpId='0001'
--set @IsAdmin=0
if (Not exists(select 1 from sys_user u inner join sys_whuser w on u.LoginId=w.UserId and w.WhId=@WhId and u.Password=@Password and u.Isuse=1)) and ((select IsAdmin from sys_user where LoginId=@LoginId and Password=@Password)<>1)
return 0
return 1-------------------
谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货