Explain insert into select statement?



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

Post New Answer

More SQL Server Interview Questions

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


How to concatenate two binary strings together?

1 Answers  


Is sql server implemented as a service or an application? : Sql server database administration

1 Answers  


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1 Answers   Global Logic,


How to set database to be read_only in ms sql server?

1 Answers  


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

1 Answers   Aviva,


What is oltp (online transaction processing)?

1 Answers  


What is the osql utility?

1 Answers  


What are logical/boolean operations in ms sql server?

1 Answers  


Explain what are the authentication modes in sql server?

1 Answers  


what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,


Categories