34,593
社区成员
发帖
与我相关
我的任务
分享
-- drop table moblie,tmp
create table moblie(name varchar(10),sheng varchar(10))
create table tmp(prov varchar(10))
insert into moblie(name)
values('dd'),('y'),('hj'),('bn'),('re'),('hf'),('dfds'),('oio'),('er'),('df')
insert into tmp(prov)
values('43'),('56'),('24'),('65'),('66'),('34'),('7'),('0'),('34'),('33')
-- select * from [dbo].moblie
-- select * from [dbo].tmp
;with moblie2 as(
select row_number()over(order by (select 0)) id,name,sheng from [dbo].moblie
), tmp2 as(
select row_number()over(order by (select 0)) id,prov from [dbo].tmp
)
update a set a.sheng = b.prov
from moblie2 a inner join tmp2 b on a.id=b.id