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!