create procedure selectUserInfo
@UserName varchar(20),
@PassWord varchar(20)
as
select count(*) from UserInfo where UUserName=@UserName and UPassWord=@PassWordexec selectUserInfo @UserName='admin',@PassWord='1'执行这个存储过程如果没有数据如何让他在第一行第一列显示一个0
@UserName varchar(20),
@PassWord varchar(20)
as
select count(*) from UserInfo where UUserName=@UserName and UPassWord=@PassWordexec selectUserInfo @UserName='admin',@PassWord='1'执行这个存储过程如果没有数据如何让他在第一行第一列显示一个0
@UserName varchar(20),
@PassWord varchar(20)
as
declare @counter int;
set @counter = select count(*) from UserInfo where UUserName=@UserName and UPassWord=@PassWord
if @counter < 1
select 0;
else
select @counter;
create procedure selectUserInfo
@UserName varchar(20),
@PassWord varchar(20)
as
select isnull(count(*),0) as Total
from UserInfo where UUserName=@UserName and UPassWord=@PassWordexec selectUserInfo @UserName='admin',@PassWord='1'
create procedure selectUserInfo
@UserName varchar(20),
@PassWord varchar(20),
@Result int output
as
select count(*) from UserInfo where UUserName=@UserName and UPassWord=@PassWord
--------------------
declare @a int
set @a=0
exec selectUserInfo @UserName='admin',@PassWord='1',@a output
select @a
select Totalcount = count(*) from dbo.UserInfo