sql 同时向表里插入多条数据

如向表里同时插入学号，姓名，年龄

INSERT INTO Student
       (TABLE ('01001','张三',19),
                ('01002','李四',18）,
                ('01003','王五',20))

或者

with studentTemp as
(
SELECT '01001','张三',19 UNION ALL
SELECT '01002','李四',18 UNION ALL
SELECT '01003','王五',20)
insert into 学生表 select * from studentTemp

PS：我的淘宝店铺新开业，经营各种桌游，棋牌，希望大伙儿能来看看！http://201314yes.taobao.com/

转载于:https://www.cnblogs.com/jenney-qiu/archive/2012/02/28/2371427.html