[导入]表变量在存储过程中出现了"必须声明变量"的错误,已经声明了啊
如果表名要用变量给定,要用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
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