python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions