日期:2014-05-17 浏览次数:20550 次
--指定不行,有几个结果集就返回几个。可以封闭个存储过程 CREATE PROC up_test @totalcount int OUTPUT AS SET NOCOUNT ON SELECT @totalcount = COUNT(*) FROM dbo.A SELECT * FROM dbo.B GO DECLARE @total INT EXEC up_test @total OUTPUT