如果表名要用变量给定,要用exec()
eg:
DECLARE @Order Table(OrderNo varchar(50)),
@sql varchar(8000)
select @sql='Insert
'+@Order+' Select OrderNo From TableB'
exec(@sql)
文章来源:
http://bbs.fzonet.com/rcds/ShowPost.asp?ThreadID=1632
转载于:https://www.cnblogs.com/fzonet/archive/2008/02/20/1092776.html