ºÏ²¢×Ö¶ÎsqlÇó½â - MS-SQL Server / Ó¦ÓÃʵÀý

ÎÊÌ⣺
A±íÖÐÓÐ3¸ö×ֶΣ¬·Ö±ðÊÇa1(varchar)£¬a2(int)£¬a3(char(3))
B±íÖÐÓÐ2¸ö×ֶΣ¬·Ö±ðÊÇb1(varchar),b2(int)
ÐèÒª½«A±íÖеÄ3¸ö×ֶκϲ¢³ÉÒ»¸ö×Ö·û´®£¬Ð´Èëµ½B±íµÄb1×ֶΣ¬Í¬Ê±b2´Ó1¿ªÊ¼¼Ó1.

±ÈÈ磺 A±íÖÐ a1 a2 a3
  F 21 WWW
  W 15 HHHH
  X 16 CCC
  B±íÓ¦¸ÃÊÇ
  b1 b2
  F21WWW 1
  W15HHH 2
  X16CCC 3

¶àл¡£
 

---

SQL code:
insert into B(b1,b2)
select a1+rtrim(a2)+a3 , row_number() over (order by getdate())
from A

---

SQL code:
select a1+ a2 +a3 as b1, identity(int,1,1) as b2 into #b
ÔÙ
insert into b select * form #b

---

SQL code:

--> ²âÊÔÊý¾Ý£º[TA]
if object_id('[TA]') is not null drop table [TA]
create table [TA]([a1] varchar(1),[a2] int,[a3] varchar(4))
insert [TA]
select 'F',21,'WWW' union all
select 'W',15,'HHHH' union all
select 'X',16,'CCC'

select b1=a1+rtrim(a2)+a3,b2=Row_Number() over(order by a1) into TB
from [TA]

select * from T