View Single Post

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

You can use 3-part naming like :

USE database1
GO
INSERT tbl(col1, col2, ...coln)
SELECT col1, col2, ..coln
FROM database2.dbo.tbl ;

--
--- Anith


Reply With Quote