How to insert multiple rows with one insert statement in ms sql server?



How to insert multiple rows with one insert statement in ms sql server?..

Answer / Reeta Verma

In MS SQL Server, you can use the INSERT INTO statement with VALUES and multiple comma-separated tuples to insert multiple rows: INSERT INTO table_name (column1, colum
2...) VALUES (values1), (values2), ...; Each tuple corresponds to a row in the table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is difference between oltp and olap?

1 Answers  


Explain alternate key, candidate key and composite key in sql server?

1 Answers  


Explain about temporary stored procedure?

1 Answers  


What do you think of this implementation? Can this be implemented better?

1 Answers  


What is the difference between getdate and sysdatetime?

1 Answers  


When cursors are useful?

1 Answers  


How do I change my passwords (database, LDAP, and so on) without causing an outage?

1 Answers   IBM,


How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  


What is the difference between char and varchar2 datatype in sql?

1 Answers  


Does sql server 2000 full-text search support clustering?

1 Answers  


what is IDE,DMV in sql server?

1 Answers   Value Labs,


Categories