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     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas