如果表名要用变量给定,要用exec()
eg:
DECLARE @Order Table(OrderNo varchar(50)),
@sql varchar(8000)
select @sql='Insert
'+@Order+' Select OrderNo From TableB'
exec(@sql)
转载于:https://www.cnblogs.com/Donkey/archive/2010/07/14/1776977.html