Multiple insert using one insert statement in SQL 2008
Multiple insert using one statement in SQL 2008
Insert all records into table using the Row constructor
INSERT INTO USER(ID, NAME)
VALUES(1,'userA'),
(2,'userB'),
(3,'userC'),
(4,'userD'),
(5,'userE'),
(6,'userF'),
(7,'userG'),
(8,'userH'),
(9,'userI'),
(10,'userJ')
Insert all records into table using the Row constructor
INSERT INTO USER(ID, NAME)
VALUES(1,'userA'),
(2,'userB'),
(3,'userC'),
(4,'userD'),
(5,'userE'),
(6,'userF'),
(7,'userG'),
(8,'userH'),
(9,'userI'),
(10,'userJ')
Labels: multi insert, row constructor
posted by Unknown at
2:41 PM
|
0 Comments
