Insert multiple data in a single insert statement – SQL Server 2014

So often when people insert initial data into the database (whether via migration or post deployment scripts), they repeat the ‘insert into’ for each data value. i.e

However there is a quicker way to insert without having to repeat the ‘insert into’ statement

 

Like this post?

Leave a Reply

Your email address will not be published. Required fields are marked *