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 create table [dbo].[test]( [number] [int] not null ) insert into dbo.test (number) values (1); insert into dbo.test (number) values (2); insert into dbo.test (number) values (3); insert into … [Read more…]