View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:12 PM
Henri
 
Posts: n/a
Default Querying tables from different databases

Hello,

I am quite new to ms-sql and I have a problem : I want to create an SQL
request which would copy serveral records from a table in a given database
to another table (with exactly the same structure) in another database
(theses two tables and databases already exist).

Could you please tell me how to do this ? I dont know how to access two
different databases in a single SQL request.

Thank you for you help.



Reply With Quote