declare @table table(id int)
insert into @table select id from DEF_Boxview;
declare @sql varchar(200)
set @sql='select * from'+ @table+' where id =1'
exec(@sql)出现的错误是:必须声明标量变量 "@table"。
insert into @table select id from DEF_Boxview;
declare @sql varchar(200)
set @sql='select * from'+ @table+' where id =1'
exec(@sql)出现的错误是:必须声明标量变量 "@table"。
set @sql='declare @table table(id int)
insert into @table select id from DEF_Boxview;
select * from @table where id =1'
exec( @sql)
这样试过了 错误必须声明标量变量 "@table"。
set @sql='select * from'+ @table+' where id =1'
exec(@sql)
直接 select * from @table where id =1 不就可以了吗?