Programmer's Rules


How to use Transact-SQL to insert multiple rows in one INSERT statement

A simple example of an INSERT statement variant in Transact-SQL

Transact-SQLjob interviewSQL Server70-761

When inserting one data row into a table we can use the following formula:

But if you need to insert many rows at a time, it is possible to separate the value list with a comma, use the following syntax:

Tutorial statistics