存贮过程中传出参数的？？？

[user918]

如果我存储过程执行一个动态的SQL语句，我怎样能得到他的子段，在把他传给我现在的存贮过程的一个变量。示例如下：
DECLARE @TABLE VARCHAR(20)
DECLARE @RecordCount int
DECLARE @DYSQL VARCHAR(200)
SET @DYSQL= 'SELECT COUNT(*) FROM '+@TABLE
SP_EXECUTESQL @DYSQL
现在我想把@DYSQL执行的结果在传给变量@RecordCount该如何操作啊？？？

[pengdali]

DECLARE @TABLE VARCHAR(20)
DECLARE @RecordCount int
DECLARE @DYSQL NVARCHAR(2000)
SET @DYSQL= 'SELECT @a=COUNT(*) FROM '+@TABLE

exec sp_executesql @sql,N'@aint output',@RecordCount output

[pengdali]

DECLARE @TABLE VARCHAR(20)
DECLARE @RecordCount int
DECLARE @DYSQL NVARCHAR(2000) --注意是nvarchar
SET @DYSQL= 'SELECT @a=COUNT(*) FROM '+@TABLE

exec sp_executesql @DYSQL,N'@a int output',@RecordCount output

[zjcxc]

create proc p_test
@TABLE VARCHAR(20),
@RecordCount int out
as
DECLARE @DYSQL nVARCHAR(2000)
SET @DYSQL= 'SELECT @RecordCount=COUNT(*) FROM '+@TABLE
exec SP_EXECUTESQL @DYSQL,N'@RecordCount int out',@RecordCount out
go

--调用:
declare @RecordCount
exec p_test 'aa',@RecordCount out
select 结果=@RecordCount

[txlicenhe]

exec sp_executesql @DYSQL,N'@a int output',@RecordCount output

http://expert.csdn.net/Expert/topic/2364/2364046.xml?temp=.829693
[交流]动态SQL语句