Çó¼òµ¥SQLÓï¾äÔÚÏßµÈ

SQL code:

Êý¾Ý¿âa
select code,name from A

Êý¾Ý¿âb
select code,name from B

A±íÊdzýÁËÕâÁ½¸ö×ֶλ¹ÓÐÆäËûºÃ¶à×Ö¶Î,B±í¾ÍÖ»ÓÐÕâÁ½¸ö×Ö¶Î
ÏÖÒª½«Êý¾Ý¿âaµÄA±íµÄcodeºÍname²éѯ³öÀ´ºó·Åµ½Êý¾Ý¿âbµÄB±í

---

ÔÚÊý¾Ý¿âb²Ù×÷
Insert into B (code,name) select code,name from a.dbo.A

---

SQL code:

--SINPOAL

select code,[name] into B from A

---

ѧϰ£¡£¡

---

SQL code:
insert into b..B(code,name)
select code,name from a..A

---

insert in to b..B(code,name)
select code,name from a..A

---

insert B select  code,name from A

---

select code,name into B from A  //Èç¹ûB±í²»´æÔÚ
insert into B select code,name from A  //Èç¹ûB±íÒÑ´æÔÚ

---

SQL code:


Êý¾Ý¿âb
INSERT B..B (code,name) select code,name from A..A