Re: Reference to more than one table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/20/04


Date: Fri, 20 Feb 2004 15:56:14 +0100

Correct. Alias support is planned for Yukon, so with Yukon the code could
refer to an alias name and when changes occurs, only the alias definitions
would need to change...

-- 
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:%230uAL469DHA.4084@tk2msftngp13.phx.gbl...
> Hi,
>
> I feel that it is not possible in SQL Server.
>
> Thanks
> Hari
> MCDBA
>
> "Krishna" <kishore30@hotmail.com> wrote in message
> news:6C17B2D7-B946-41F7-83E0-557C9CBA043C@microsoft.com...
> > Hi
> >
> > In most of my stored procedure's i have to reffer more than one database
> to pull out the data, when ever the database name changes i have to update
> all of my stored procedure to use the new name, which is bit time
consuming
> for me at the moment.
> > Is there any way to minise the effort by just changing in the
configuation
> file or like a global variable ect.,
> >
> > Regards,
> > Krishna
>
>


Relevant Pages

  • Re: Problem on quering Access link table
    ... Is "Alias" a field in the Exchange table? ... > simply test the recordset for BOF/EOF? ... > Access Database Samples: www.rogersaccesslibrary.com ... I wrote ASP code to use Alias ...
    (microsoft.public.access.queries)
  • Re: Select from open view using DBF()
    ... So you created an alias like this? ... At any rate as I mentioned I'm using a parameterized view in a database. ... will not see any un-saved changes as VFP appears to do a USE AGAIN and ... I have worked around it by using copy to array and other commands, ...
    (microsoft.public.fox.vfp.dbc)
  • Re: SCR and Replay Queue length
    ... Are you also able to get the file attributes for the seeding directory using attrib? ... This posting is provided "AS IS" with no warranties, ... Please do not send email directly to this alias. ... > permon when trying to seed the database and didn't see anything out of> the ...
    (microsoft.public.exchange.admin)
  • Re: Serious errors with Create view command
    ... Either you open each view as needed with a different alias and assign this ... stored in the database, ... Edit Stored Procedures opens a code editing window and saves the code you ... can't paste it INTO the view designer sql view window as that's Read ...
    (microsoft.public.fox.helpwanted)
  • Re: Priv1.edb and stm size cannot reduce after eseutil /d
    ... it would mount with blank a database. ... Please do not send e-mail directly to this alias. ... it was four o'clock by the time I got the defrag copy on to ... > the drive, if I had mistype the name, would the services start again? ...
    (microsoft.public.exchange.admin)