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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.