Dofactory.com
Dofactory.com
 Back to list
Views:   2.2K
Replies:  1
Archived

sql 2008 - INSERT INTO

Wants to move(copy) data from different DATABASE

Server Name is :WIN-GIGA\SQLEXPRESS
Database names are
        1:RUNDATA
        2:BAKDATA
And in both the DATABASE ONE TABLE is common ie. Product
now i wants to copy the content of table from 'RUNDATA\Product'   TO BAKDATA\Product

what will be the query for vic versa Database...



Azka Shaikh, Feb 17, 2018
Reply 1
INSERT INTO table2 SELECT * FROM table1 WHERE condition;
Amrutha Prathik, May 01, 2018
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.