兩種方法: 1. 將if @userid!=null改為: if @userid is not null 2. 設置ansi_null選項值
ALTER PROCEDURE sp_Accounts_ValidLogin @username varchar(50), @password varchar(50) AS declare @userid int select @userid=id from admin where username=@username and password=@passwordif @userid is null return -1 else return @userid go
--建议使用的方法: ALTER PROCEDURE sp_Accounts_ValidLogin @username varchar(50), @password varchar(50) @userid int out as select @userid=id from admin where username=@username and password=@passwordif @userid is null set @userid=-1 go--调用示例: declare @userid int exec sp_Accounts_ValidLogin '张三','12',@userid out select 结果=@userid
1. 將if @userid!=null改為: if @userid is not null
2. 設置ansi_null選項值
@username varchar(50),
@password varchar(50)
AS
declare @userid int
select @userid=id from admin where username=@username and password=@passwordif @userid is null
return -1
else
return @userid
go
ALTER PROCEDURE sp_Accounts_ValidLogin
@username varchar(50),
@password varchar(50)
@userid int out
as
select @userid=id from admin where username=@username and password=@passwordif @userid is null set @userid=-1
go--调用示例:
declare @userid int
exec sp_Accounts_ValidLogin '张三','12',@userid out
select 结果=@userid