Database Alias

Hi,
Is there any way to set up an alias for a database within an SQL script?
What I'm trying to acheive is... instead of having -
<DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout the
script, I just set up an alias at the top of the script and reference them.

TIA
BenPrefix your query with USE...

USE dbname
Select * from tblName

You can also alias table names by putting the alias after the table name in
the from clause...

Select p.firstName, p.lastName from tblPeople p

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz

"Ben" <ben.kinslow.nospam@.baesystems.plznospam.com> wrote in message
news:3fbb5e8e$1@.baen1673807.greenlnk.net...
> Hi,
> Is there any way to set up an alias for a database within an SQL script?
> What I'm trying to acheive is... instead of having -
> <DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout the
> script, I just set up an alias at the top of the script and reference
them.
> TIA
> Ben|||Thanks a lot... but...
I have a script that accesses two databases throughout. I *guessed* that
you could only have one USE statement in effect at any one point.

I am new to this, so any help is useful.

Jerry Boone <jerry@.antech.biz.killspam> wrote in message
news:N7Nub.1447$5x1.4@.newssvr22.news.prodigy.com.. .
> Prefix your query with USE...
> USE dbname
> Select * from tblName
>
> You can also alias table names by putting the alias after the table name
in
> the from clause...
> Select p.firstName, p.lastName from tblPeople p
>
> --
> Jerry Boone
> Analytical Technologies, Inc.
> http://www.antech.biz
>
> "Ben" <ben.kinslow.nospam@.baesystems.plznospam.com> wrote in message
> news:3fbb5e8e$1@.baen1673807.greenlnk.net...
> > Hi,
> > Is there any way to set up an alias for a database within an SQL script?
> > What I'm trying to acheive is... instead of having -
> > <DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout
the
> > script, I just set up an alias at the top of the script and reference
> them.
> > TIA
> > Ben|||Also

declare @.tblname varchar(100)
set @.tblname = '<DatabaseName>.dbo.table'
exec ( 'select * from ' + @.tblname)

On Wed, 19 Nov 2003 12:17:44 -0000, "Ben"
<ben.kinslow.nospam@.baesystems.plznospam.com> wrote:

>Hi,
>Is there any way to set up an alias for a database within an SQL script?
>What I'm trying to acheive is... instead of having -
><DatabaseName>.dbo.table, <DatabaseName2>.dbo.table, etc. - throughout the
>script, I just set up an alias at the top of the script and reference them.
>TIA
>Ben