在A库中运行:
insert aa(col1,col,....) select col1,...,col(自定义也行) from a..ba
insert aa(col1,col,....) select col1,...,'ddf' as coln from a..ba
insert aa(col1,col,....) select col1,...,col(自定义也行) from a..ba
insert aa(col1,col,....) select col1,...,'ddf' as coln from a..ba
insert aa(col1,col,....) select col1,...,col(自定义也行) from b..ba
insert aa(col1,col,....) select col1,...,'ddf' as coln from b..ba
select 列1,列3,列4,列5,列2=某值 from B.dbo.ba其他几行数据,如果是定值就好办,不是固定的那么就只有用动态语句来做了
在上述语句中,若想根据ba表中某一列的值给aa表中确定一个新值,
该如何做?谢谢!
insert A.dbo.aa(列1,列3,列4,列5,列2)
select 列1,列3,列4,列5,列2=列1+某值 from B.dbo.ba