insert into select in sql server. PART 7

insert into select in sql. insert into select in sql. Part 7
how to insert all record or a specific record from one sql table to another sql table in sql server database.
the sql statement INSERT INTO SELECT copies data from one table to another table.

NOTED that number of column what you want to select and insert must match.

sql statement
INSERT INTO table2 SELECT * FROM table1 WHERE condition
~~~~~~~~~~~~~
Subscriber will be notified when I will upload new tutorials in future. Many more new tutorials coming soon, so stay tuned!
https://www.youtube.com/swiftlearn
~~~~~~~~~~~~~
You can also know all the programming techniques, and bug fixing, error solution in my channel Swift learn.
The main topics of this channel are c#.net, asp.net, WCF, sql server, crystal report, RDLC report, HTML, CSS, javascript, Android etc.
~~~~~~~~~~~~~
Share this video with anyone if you think as useful.
Please leave any suggestions for future tutorials in the comment section below.
~~~~~~~~~~~~~

Connect with me
https://www.facebook.com/groups/swiftlearn/

All playlist
c# tutorial for beginners Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyXoPn0-4NIdFn8RrQQDdAki
c# linq to sql tutorial Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyVsic1g2CUn2pR5aKjNd3Nc
asp.net tutorial for beginners full Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyUjmHrYfAq1l8pe5eXhkZqF
crystal report c# in sql Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyWao6CC3Eu0srQxJjgkfLsm
SQL Tutorial for beginners full Swift Learn
https://www.youtube.com/playlist?list=PLINPYKVRUHyVOv6mx6xU7HEgGcfLk4Kmz

For Details
insert into select in sql,insert all record from one table to another table in sql,insert into select,insert into select statement,insert into sql,insert into sql server,sql server,insert into select sql server,sql insert into select values,sql insert into select foreign key,insert into select in sql server. part 7,sql tutorial for beginners full,swift learn