insert  进入 SE1.table1（column1，comumn2，colum3）选择 col1，col2，col3 来自 SE2.table2 其中 SE2.table2.Destination 赞 ' ％HR％' 

查看此链接。



http ：//***.com/questions/ 2927199 / copy-data-from-one-sql-server-database-table-to-other [ ^ ]

http ：//social.msdn.microsoft.com/Forums/sqlserver/en-US/f5ee85c7-c9d3-438e-a835-daa2c785026b/copy-sql-database-tables-to-another-sql-server论坛= sqlgetstarted [ ^ ]

使用导入或导出数据......：）

Hi,
I have two sql servers, SE1 and SE2, they are basically having the same schema, but each one has its own usability.
I need to find a query to copy some rows from SE1.Table1 Where Destination Like '%HR%' to SE2.Table2.
Is there such query ??
Thx in advance.

insert into SE1.table1 (column1,comumn2,colum3) select col1,col2,col3 from SE2.table2  Where SE2.table2.Destination Like '%HR%'

Check this links.

http://***.com/questions/2927199/copy-data-from-one-sql-server-database-table-to-the-other[^]
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f5ee85c7-c9d3-438e-a835-daa2c785026b/copy-sql-database-tables-to-another-sql-server?forum=sqlgetstarted[^]

use import or export data....:)