Copy data from one server to another server by sql query

Question

Hi Everone,

 

I am stuck in one situation where i need data from one server table data to another server table data through sql .

Is there any query or method to import data  without import/export of GUI.