Insert the multiple records using single sql query

Posted by Karthikreddy under Sql Server category on | Points: 40 | Views : 1002
we added a single record to each use of the INSERT operation. You can add various records with one call to INSERT. If you are adding a value to each column of the table, after the name of the table, type VALUES, open and close the first parentheses. Inside the parentheses, include the desired values. To add another record, type a comma after the closing parenthesis, open a new parenthesis, list the new values, and close the parenthesis. Do this as many times as you need to add records.

Here is an example:

use jkarthik

create table videos
Title nvarchar(50),
Director nvarchar(50),
YearRelesed Int
insert into videos values('Shadow','skkjjjk',2013),

Comments or Responses

Login to post response