how i can copy data from a table on server1 to another table on server2 using query?
Asked
Active
Viewed 108 times
-1
-
2Refer: http://stackoverflow.com/questions/11009189/export-table-data-from-one-sql-server-to-another – Kinchit Dalwani Apr 27 '17 at 10:44
-
@MahdiBagheri Using Jquery?? – Jibin Balachandran Apr 27 '17 at 10:53
-
@JibinBalachandran No.Using Query on sql – Mahdi Bagheri Apr 27 '17 at 11:00
-
This post shows zero research or effort on your part. – dfundako Apr 27 '17 at 14:29
1 Answers
0
INSERT INTO [server2].[database].[schema].[table]
( col1, col2, col3...)
SELECT
( col1, col2, col3...)
FROM [server1].[database].[schema].[table]
server2 would need to be a linked server
Mazhar
- 3,757
- 1
- 11
- 28