Refering to multiple databases

I know i can switch the currently refered
database by choosing a different name in
the drop-down menu. However, i'd like to
programmatically pick a database.

I'd like to compare the same search from
two databases as follows.

select * from olds.stuff
select * from news.stuff

How can i do that?

--


Regards
Konrad Viltersten
----------------------------------------
May all spammers die an agonizing death;
have no burial places; their souls be
chased by demons in Gehenna from one room
to another for all eternity and beyond.

> I'd like to compare the same search from
> two databases as follows.
>
> select * from olds.stuff
> select * from news.stuff
>
> How can i do that?

Use 3-part names:

select * from olds.dbo.stuff
select * from news.dbo.stuff

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/