Can I insert multiple records in table by one query in SQL ?

Answer 1

Yes, sure. You could use the following code:
Insert into ... (...) values (your first record), (your second record), and so on. After the last bracket you should use the semicolon.

Answer 2

sure..insert into tablename values(1,'john'),(2,'randy'),(3,'goldberg').......we can insert multiple records by using comma(,) between rows.

Answer 3

Sure just split them by using a brackets and a ","

Answer 4

yes, you can make with INSERT INTO query.

Answer 5

yes, sure

Answer 6

Yes you can.

Answer 7

yes using comma,&brackets and finally semicolons to close

Answer 8

yes of course by using this query insert into table name values(add values in the same order),(add values in the same order);

Answer 9

here's a handy trick.

if you have data in one table and what to insert into another table such as a temp table you can do

insert into [tableName] ([colName],[colName]..)
select colName, colName.. from tableName where..