SQL insert from select query

SQL Server INSERT from SELECT query

There are following ways to INSERT and SELECT statements in the table.

1.       You can use the INSERT statement to specify values directly.
2.       You can use the INSERT statement to specify values from a sub-query.
3.       You can use the SELECT statement with the INTO clause.

Syntax :

INSERT [INTO] Table_Name (COLUMNS) Table_Values

Example:

You can use the below query for insert rows.

INSERT INTO [dbo].Users (ID, Name, DepName)
   SELECT ID, Name, DepName
                FROM [dbo].OldUsers


If you have same columns in the both tables (destination and source) that time you can use below query for insert rows.

INSERT INTO [dbo].Users
  SELECT *  FROM dbo.Customers


I think, It might help you. Thank you!
ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

SQL Server INSERT from SELECT query SQL Server INSERT from SELECT query Reviewed by Anil Singh on 12:00 PM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^