--指定不行,有几个结果集就返回几个。可以封闭个存储过程 CREATE PROC up_test @totalcount int OUTPUT AS SET NOCOUNT ON SELECT @totalcount = COUNT(*) FROM dbo.ASELECT * FROM dbo.BGODECLARE @total INT EXEC up_test @total OUTPUT
--A表的行数 declare @count int select @count= COUNT(*) from A select @count --B表的结果 select * from B 如果你要获取B表的结果集,可以把查询B表的语句放在前面啊
CREATE PROC up_test
@totalcount int OUTPUT
AS
SET NOCOUNT ON
SELECT @totalcount = COUNT(*) FROM dbo.ASELECT * FROM dbo.BGODECLARE @total INT
EXEC up_test @total OUTPUT
--A表的行数
declare @count int
select @count= COUNT(*) from A
select @count
--B表的结果
select * from B
如果你要获取B表的结果集,可以把查询B表的语句放在前面啊