--执行
create table tb(...) insert into tb EXEC (N'DECLARE '+@sql1+N'
SELECT '+@sql2+N'
SELECT '+@sql3+N' FROM #execSQLDBDB
EXEC (N'+@sqlhead+N'+'+@sql4+N'+N'+@sqlend+N')')
create table tb(...) insert into tb EXEC (N'DECLARE '+@sql1+N'
SELECT '+@sql2+N'
SELECT '+@sql3+N' FROM #execSQLDBDB
EXEC (N'+@sqlhead+N'+'+@sql4+N'+N'+@sqlend+N')')
insert into T
Exec Proc
在动态SQL 里写好
select column1,column2 into ##Tab from TabA