select via database name alias?

[hbaake]

Is there a way in SQLServer2000 to select data via a database name Alias?

I would like to join two tables on different databases (or even different servers), but I don't want to change all the server.databasename.owner table prefixes everytime the script is run on a different server...

So, can 'SELECT server1.databasename1.owner1.table1.col1 ...' be changed into 'SELECT dbalias1.table1.col1 ...' ?

Thanks for your help,
Hugo.

 

[Cagliostro]

select VeryLonaName x from xxx where
x=somevalue

or
select t.a x, t.b y from (select xxx a, yyy b from zzz) t
where
x=somevalue or y=theotherone John Fill

ivfmd@mail.md

 

[rajeevnandanmishra]

Hi Hugo,
For these special cases i use dynamic sqls in my scripts.
take a look at thread
thread183-108556