Îʸösql µÄinsertµÄÎÊÌâ

Ìí¼ÓÒ»¸öѧÉú³É¼¨µÄ¼Ç¼
Êý¾Ý¿âÖÐÓРѧÉú±í£¨ID£¬Name£©
³É¼¨±í  £¨·ÖÊý£¬studentID£©


ÏÖÔÚ²åÈëÊý¾ÝµÄÄÚÈÝÊÇ Ñ§ÉúÐÕÃûºÍ³É¼¨
SQL Óï¾äÔõôд().....

---

SQL code:
INSERT TB (ÐÕÃû,³É¼¨) SELECT NAME,·ÖÊý from ѧÉú±í A,³É¼¨±í B WHERE A.ID=B.studentID

---

SQL code:
insert into student values('01','ÕÅÈý');
insert into score values('01','·ÖÊý');

ÄãµÄѧÉúidÒªÔõôÉú³É£¬×ÔÔöÂð»¹ÊÇassigned

---

SQL code:
insert into tb(ÐÕÃû,³É¼¨) select a.name,b.·ÖÊý from ѧÉú±í a,³É¼¨±í b where a.id=b.studentid)

---

ºÃ¾ÃûÓÃÁË£¬¾ÍÊDz»ÖªµÀ.¶¼¿ìÍüÁË....

---

ÐÂÔöÒ»條記錄時ÓÃ

學Éú為ÐÂÉú時
SQL code:
--ID為×ÔÔöÁÐ時
Declare @ID int
insert ѧÉú±í(Name) values('張Èý')
set @ID=@@Identity
insert ³É¼¨±í(·ÖÊý,studentID) values(60,@ID)


--學Éú´æÔÚ時
SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/