22,300
社区成员
发帖
与我相关
我的任务
分享[求助一个问题]关于动态SQL语句的执行!在线等候,谢谢!!!
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没有返回数据,这是为什么,请高手指点,谢谢!!!
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没有返回数据,这是为什么,请高手指点,谢谢!!!
...全文
请发表友善的回复…
发表回复
txlicenhe 2003-12-17
- 打赏
- 举报
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
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
lqlin 2003-12-17
- 打赏
- 举报
可以了,谢谢!!
txlicenhe 2003-12-17
- 打赏
- 举报
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
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
zjcxc 2003-12-17
- 打赏
- 举报
--用错了,用下面的就可以了.
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
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
