34,576
社区成员
发帖
与我相关
我的任务
分享
哪果是加进去:
alter table tb1 add 添加的列名 数据类型
go
;with t1 as
(
select rn=row_number()over(order by getdate()),* from tb1
)
,t2 as
(
select rn=row_number()over(order by getdate()),合并的列 from tb2
)
update t1 set
t1.刚才添加进去的列=t2.要复制数据过来的列
from t2
where t1.rn=t2.rn
--2005
;with t1 as
(
select rn=row_number()over(order by getdate()),* from tb1
)
,t2 as
(
select rn=row_number()over(order by getdate()),合并的列 from tb2
)
select a.*,b.合并的列
from t1 a
join t2 b
on a.rn=b.rn