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?