Çó Æ´VB SQL insert into ×Ö·û´®

  INSERT INTO StudAchieve(studID,studName)
  VALUES('2','abc'),('2','bcd'),('2','cde')

  Æ´ÁË°ëÌìÒ²²»¶Ô£¬¼°°¡ ¡£¡£¡£¡£

---

SQL code:
INSERT INTO StudAchieve(studID,studName)
select '2','abc'
union all select '2','bcd'
union all select '2','cde'

---

SQL code:
INSERT INTO StudAchieve(studID,studName)
select '2' studID,'abc' studName union all
select '2','bcd' union all
select '2','cde'

---

INSERT INTO StudAchieve(studID,studName)
  VALUES('2','abc')

---

SQL code:
--try
INSERT
StudAchieve(studID,studName)
select
'2','abc'
union all
'2','bcd'
union all
'2','cde'

---

ÒýÓÃ

INSERT INTO StudAchieve(studID,studName)
   VALUES('2','abc'),('2','bcd'),('2','cde')

  Æ´ÁË°ëÌìÒ²²»¶Ô£¬¼°°¡ ¡£¡£¡£¡£

Õâ¸öÊÇsql2008µÄÓï·¨°É

---

2008µÄÓï·¨ÊǶԵÄ

---

1¡¢2Â¥µÄÊÔÒ»ÊÔ

---

SQL code

---

Code highlighting produced by Actipro Cod