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 |
What is difference between oltp and olap?
Explain alternate key, candidate key and composite key in sql server?
Explain about temporary stored procedure?
What do you think of this implementation? Can this be implemented better?
What is the difference between getdate and sysdatetime?
When cursors are useful?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
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
What is the difference between char and varchar2 datatype in sql?
Does sql server 2000 full-text search support clustering?
what is IDE,DMV in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)