[求助一个问题]关于动态SQL语句的执行!在线等候,谢谢!!!

[lqlin]

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没有返回数据,这是为什么,请高手指点,谢谢!!!

[zjcxc]

--用错了,用下面的就可以了.

DECLARE @column_count INT
declare @table_name varchar(20)
declare @sql nvarchar(600)

set @table_name = 'scrwdwj'

set @sql = N'select @column_count=count(name) from syscolumns where id in (select id from sysobjects where name ='''+ @table_name+''')'
exec sp_executesql @sql, N'@column_count int output',@column_count output

print @column_count

[txlicenhe]

DECLARE @column_count INT
declare @table_name varchar(20)
declare @sql nvarchar(600)

set @table_name = 'usr_mstr'

set @sql = N'select @column_count = 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

[lqlin]

可以了,谢谢!!

[txlicenhe]

DECLARE @column_count INT
declare @table_name varchar(20)
declare @sql nvarchar(600)

set @table_name = 'scrwdwj'

set @sql = N'select @column_count = 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