Views: 2.2K
Replies: 1
Archived
|
sql 2008 - INSERT INTOWants 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 1INSERT INTO table2
SELECT * FROM table1
WHERE condition;
Amrutha Prathik, May 01, 2018
|