separating multiple lines of data to insert with comma –SQL Server 2008

 

Multiple insert in a single query by using comma separator.

insert into dbo.tbl_Demo
(id,name)
values
('1','anish'),
('2','varghese')