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

/ Leave a Comment

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 dbo.test (number) values (4);
insert into dbo.test (number) values (5);

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

insert into dbo.test
values (1),
       (2),
       (3),
       (4),
       (5)

 

Leave a Reply