Thread
:
Querying tables from different databases
View Single Post
#
3
(
permalink
)
02-28-2008, 07:12 PM
Anith Sen
Posts: n/a
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
Anith Sen