求 拼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