Archive

Archive for the ‘TSQL’ Category

Insert Multiple TSQL Rows

December 4, 2007 Leave a comment

The only easy way to insert multiple records in TSQL (and it’s quick!):

INSERT INTO TableName(Columns…)
SELECT Val1, Val2…
UNION ALL
SELECT Val1, Val2…

etc.

Advertisements
Categories: SQL, TSQL