[求助一个问题]关于动态SQL语句的执行!在线等候,谢谢!!!
lqlin 2003-12-17 10:48:18 DECLARE @column_count INT
declare @table_name varchar(20)
declare @sql nvarchar(600)
set @table_name = 'scrwdwj'
set @sql = N'select '+convert(varchar(120), @column_count) +'select count(name) from syscolumns where id in (select id from sysobjects where name ='+ @table_name+')'
exec sp_executesql @sql, N'@table_name varchar(20),@column_count int output',@table_name,@column_count output
print @column_count
但@column_count没有返回数据,这是为什么,请高手指点,谢谢!!!