(转载)表变量在存储过程中出现了"必须声明表变量"的错误
如果表名要用变量给定,要用exec()
eg:
DECLARE @Order Table(OrderNo varchar(50)),
@sql varchar(8000)
select @sql='Insert '+@Order+' Select OrderNo From TableB'
exec(@sql)
eg:
DECLARE @Order Table(OrderNo varchar(50)),
@sql varchar(8000)
select @sql='Insert '+@Order+' Select OrderNo From TableB'
exec(@sql)