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