Tuesday, February 28, 2017

Insert multiple rows using a single SQL INSERT statement


How to insert multiple rows using a single SQL INSERT statement.

INSERT INTO MyTable ( Column1, Column2 ) VALUES
( Value1, Value2 ), ( Value1, Value2 )

Example of updating SQL table with join's and subselect