ÇóSQLÓï¾ä - .NET¼¼Êõ / ASP.NET

ÓÐÁ½¸ö±í£¬½á¹¹ÍêÈ«Ïàͬ

ÎÒÏë°ÑÒ»¸ö±íµÄÊý¾ÝÈ«²¿È¡³öÀ´£¬²åÈëµ½ÁíÒ»¸ö±íÖУ¬
ÇóSQLÓï¾ä
лл

---

SQL code:
insert into Òª²åÈëµÄ±í select * from È¡³öÊý¾ÝµÄ±í

---

SQL code:
Insert into Table2(field1,field2,...) select value1,value2,... from Table1

---

ÒýÓÃ

SQL code
insert into Òª²åÈëµÄ±í select * from È¡³öÊý¾ÝµÄ±í

^

---

SQL code:

insert into table1(a,b) select a,b from table2 where id=33 order by datetme desc

---

ÒýÓÃ

SQL code
insert into Òª²åÈëµÄ±í select * from È¡³öÊý¾ÝµÄ±í

 UP! UP!

---

(select * from table1) union (select * from tabble2)
into table3

---

insert into Òª²åÈëµÄ±í select * from È¡³öÊý¾ÝµÄ±í

---

ÒýÓÃ

SQL code
insert into Òª²åÈëµÄ±í select * from È¡³öÊý¾ÝµÄ±í

up!

---

ת·¢£º
SELECT INTO ºÍ INSERT INTO SELECT Á½ÖÖ±í¸´ÖÆÓï¾ä InsertÊÇT-sqlÖг£ÓÃÓï¾ä£¬Insert INTO table(field1,field2,...) values(value1,value2,...)ÕâÖÖÐÎʽµÄÔÚÓ¦ÓóÌÐò¿ª·¢ÖбØ