Ailsom F. Heringer (Osklen) <> wrote:
> Foxers,
>
> We are developing an application that uses two distinct databases,
> the default dabatabe set in the connection string, and a second one
> used in some subqueries. Is it possible to create an alias to the
> second database ? Think about a future database migration, I don´t
> want to use the literal name of the database ("CustomerData.dbo").
>
> eg:
> SELECT A.ProdId,A.ProdName,B.Price AS CustomerPrice
> FROM Products B
> INNER JOIN CustomerData.dbo.Products B
Sorry buy you have to do exactly as you typed. B. is your alias, and you
have to define it one time.
Stephen Russell
DBA / Operations Developer
Memphis TN 38115
901.246-0159
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/436 - Release Date: 9/1/2006
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
