Insert Multiple ROWS in One SQL Query.

By 28th February 2019SQL

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.

Leave a Reply