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!