Insert Multiple ROWS in One SQL Query.

Insert Multiple ROWS in One SQL Query.


INSERT INTO [dbo].[tbl_Page]
           ([PageTitle]
           ,[Link]
           ,[Status]
           ,[CreatedDate]
           ,[Description])
     VALUES
           ('demo','demo',1,'12/11/2019','demo'),
		   ('demo','demo',1,'12/11/2019','demo'),
		   ('demo','demo',1,'12/11/2019','demo'),
		   ('demo','demo',1,'12/11/2019','demo'),
		   ('demo','demo',1,'12/11/2019','demo');

Here remamber to put comma at end of value secton expect of last section of value, at the end of last section of value, you have to put semicollon to end the insert statement.

See the image for tested result.