Back to list
Views:   2.2K
Replies:  1

sql 2008 - INSERT INTO

Wants to move(copy) data from different DATABASE

Database names are
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.