SQL²åÈëÎÊÌâ¡£ - MS-SQL Server / »ù´¡Àà

Òª²åÈëÒ»¸öÖµ£¬µ«ÊÇÌõ¼þÔÚÁíÍâÒ»¸ö±íÇëÎÊÔõôдSQL °¡£¿

ÎÒÊÇÕâÑùдµÄ
SQL code:

insert into A(xc) values('123')select name from B where name='ÕÅÈý'


¿Ï¶¨²»¶Ô

ÎÒÏë °ÑÒ»¸öÖµ²åÈëA±íµÄ xc×ֶΣ¬Ìõ¼þÊÇB±í Ãû×ÖΪÕÅÈý ²Å¿ÉÒÔ
ÇëÎÊÔõôд°¡£¿

---

SQL code:
insert A(XC) SELECT ×ֶΠfrom B where name='ÕÅÈý'

---

ÒýÓÃ

SQL code
insert A(XC) SELECT ×ֶΠfrom B where name='ÕÅÈý'

ÖµÔõô²å°¡£¿

---

A±íÖ»ÓÐÒ»¸ö×ֶεÄÇé¿öÏ¿ÉÒÔÔËÐеÄ
insert into A select name from B where name='ÕÅÈý' 

---

ÒýÓÃ

A±íÖ»ÓÐÒ»¸ö×ֶεÄÇé¿öÏ¿ÉÒÔÔËÐеÄ
insert into A select name from B where name='ÕÅÈý'

A±íÓкܶà×ֶΣ¡ Öµ¶¼Ã»ÓÐдÔõô²å°¡£¡

---

SQL code:
insert into A(xc) select '123' from B where name='ÕÅÈý'

---

SQL code:
insert into A(XC)
select name from B
where name='ÕÅÈý'

---

ÒýÓÃ

Òª²åÈëÒ»¸öÖµ£¬µ«ÊÇÌõ¼þÔÚÁí