Explain insert into select statement?
Answer / Ghanshyam Verma
An 'INSERT INTO SELECT' statement is used to insert rows from one table or query result into another table in SQL Server. The basic syntax is: INSERT INTO TargetTable (column1, column2, ...) SELECT column1, column2, ... FROM SourceTable WHERE conditions. This allows you to insert multiple records at once based on specific criteria.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to concatenate two binary strings together?
Is sql server implemented as a service or an application? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to set database to be read_only in ms sql server?
how to insert the values in 5 table at a time Using any single statement ?
6 Answers Infosys, Value Labs,
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition
What is oltp (online transaction processing)?
What is the osql utility?
What are logical/boolean operations in ms sql server?
Explain what are the authentication modes in sql server?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
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)