Have you ever wanted to insert more than one row of static text in to a SQL table using the VALUES argument? Well, this is actually pretty easy to do. To do this you just need to pass a comma delimited value list like in the example below.
Syntax
|
1 2 3 4 5 6 |
INSERT INTO Employees (LastName, FirstName) VALUES ('Gump', 'Forrest'), ('Taylor', 'Dan'), ('Blue', 'Bubba') |