[求助]存储过程返回值问题，请帮我看看

[guxido2002]

CREATE PROCEDURE ListPage
@spFields nvarchar(4000),
@spWhere varchar(2000),
@spOrder varchar(200),
@spCounts int output
AS
SET NOCOUNT ON
Declare @strSQL nvarchar(4000)
Declare @strWhere nvarchar(4000)
Declare @strOrder nvarchar(4000)
Declare @getCounts nvarchar(4000)
If @spWhere is null
Set @strWhere=''
Else
Set @strWhere=' Where '+@spWhere

If @spOrder is null
Set @strOrder='Order By info_id DESC'
Else
Set @strOrder='Order By '+@spOrder


Set @getCounts=N'SELECT @spCounts = COUNT(*) FROM TableA'+@strWhere
Exec sp_executesql @getCounts,N'@spCounts int output',@spCounts output
/*就是上边这段，为什么我老得不到返回值@spCounts，请问该怎么写？大家帮忙！谢谢*/

SET @strSQL='SELECT '+@spFields+' FROM TableA'+@strWhere+@strOrder
Exec(@strSQL)
GO

[guxido2002]

顶一下

[3573745]

别用＊号好不
随便改为你一个字段看看咯