<t>In SQL Server 2008 you can insert multiple rows using a single INSERT statement.<br/>
<br/>
INSERT INTO MyTable ( Column1, Column2 ) VALUES<br/>
( Value1, Value2 ), ( Value1, Value2 )<br/>
<br/>
```<br/>
<br/>
For reference to this have a look at MOC Course 2778A - Writing SQL Queries in SQL Server 2008.<br/>
<br/>
For example:<br/>
<br/>
```<br/>
INSERT INTO MyTable<br/>
( Column1, Column2, Column3 )<br/>
VALUES<br/>
('John', 123, 'Lloyds Office'), <br/>
('Jane', 124, 'Lloyds Office'), <br/>
('Billy', 125, 'London Office'),<br/>
('Miranda', 126, 'Bristol Office');<br/>
<br/>
```<br/>
<br/>
This syntax is, however, limited to a maximum of 1,000 rows. If you need to `INSERT` more than 1,000 rows, this can be worked around using a derived table in a `SELECT` instead, which doesn't have the same limitation:<br/>
<br/>
`INSERT INTO MyTable ( Column1, Column2, Column3 )<br/>
SELECT V.Column1,<br/>
V.Column2,<br/>
V.Column3<br/>
FROM (VALUES('John', 123, 'Lloyds Office'), <br/>
('Jane', 124, 'Lloyds Office'), <br/>
('Billy', 125, 'London Office'),<br/>
...<br/>
('Sally', 10026, 'Bristol Office'))V(Column1, Column2, Column3);<br/>
<br/>
```</t>
