Re: OPENQUERY

From: Chris (Chris_at_discussions.microsoft.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 09:49:01 -0700

Hi,
The databases are on two different servers.

"Tibor Karaszi" wrote:

> You don't need openquery for that:
>
> SELECT ...
> FROM db1.dbo.tbl1 JOIN db2.dbo.tbl2 ON...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:CA87FEE3-7776-41E1-96C1-2AF854C7ED48@microsoft.com...
> > Hi,
> > Can I join tables from two databases via OPENQUERY? Where can I find advance
> > info on OPENQUERY?
> >
> > Thanks
>
>
>

Relevant Pages

  • Re: i cannot start sqlservers service
    ... > restore backup of the master ... >> and msdb databases. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Different Collations
    ... You could always rebuild your system databases. ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Different Collations
    ... After your rebuild, you can sp_attach_db your user databases or RESTORE then (note that before ... > Tibor Karaszi, SQL Server MVP ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: stored procedure
    ... What I'm questioning is the design behind the need to create new databases all the time. ... Tibor Karaszi, SQL Server MVP ... Of do you want to keep track of your customers, if so, you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: stored procedure
    ... I still fail to see why you need separate databases or even tables for this. ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... Of do you want to keep track of your customers, if so, you ...
    (microsoft.public.sqlserver.server)
Loading