declare @tablename varchar(100)
declare @sqlstring varchar(200)
set rowcount 1
select @tablename=fieldname where ...
set @sqlstring='select * into '+@xxxxx +' from table1'
exec @sqlstring
declare @sqlstring varchar(200)
set rowcount 1
select @tablename=fieldname where ...
set @sqlstring='select * into '+@xxxxx +' from table1'
exec @sqlstring
提示找不到存储过程"select * into xxxxx from table1"
它把生成的变量看成存储过程了,EXEC只能执行存储过程吗??
谢谢!
如何给分?