--这样可以吗?--插入DB2中数据--------------------------
Declare @DB sysname
set @DB='DB1'
Exec('insert DB2 select * from '+@DB+'')--生成DB4表------------------------------
select F2-F1 as [F2-1] into DB4from DB2--生成DB5表------------------------------
select F3-F1 as [F2-1] into DB5from DB2--生成DB6表------------------------------
select F4-F1 as [F2-1] into DB6from DB2
Declare @DB sysname
set @DB='DB1'
Exec('insert DB2 select * from '+@DB+'')--生成DB4表------------------------------
select F2-F1 as [F2-1] into DB4from DB2--生成DB5表------------------------------
select F3-F1 as [F2-1] into DB5from DB2--生成DB6表------------------------------
select F4-F1 as [F2-1] into DB6from DB2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货