query table in another database

[vionca]

Hi there,

Is there any way to query a table in database A while working in a table in database B?

I needed to select data from database A and then insert it into database B. I have been using an import, but wonder if there is a better way.

Thanks,
vionca

 

[ecobb]

If it's on the same server, you would use:

Select *
From DatabaseName.Owner.TableName

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[vionca]

Oh wow! thanks!