Hi,
We are migrating to 2005 and there are some old queries that use *= in the
sql. Is it no more used?
Whats the other way to get the same functionality?
ThanksCheck out LEFT OUTER JOIN in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"mavrick_101" <mavrick101@.discussions.microsoft.com> wrote in message
news:C3A7A6B0-2CCD-4EB3-B807-23A692DCC44F@.microsoft.com...
Hi,
We are migrating to 2005 and there are some old queries that use *= in the
sql. Is it no more used?
Whats the other way to get the same functionality?
Thanks|||Are you familiar with LEFT OUTER JOIN syntax? That's what you should be
using.
"mavrick_101" <mavrick101@.discussions.microsoft.com> wrote in message
news:C3A7A6B0-2CCD-4EB3-B807-23A692DCC44F@.microsoft.com...
> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
Set database compatibility level (sp_dbcmptlevel) other than 90 (70, 80)
> Whats the other way to get the same functionality?
Left outer join (* =)
Right outer join (= *)
Full outer join (* = *)
AMB
"mavrick_101" wrote:
> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||use left outer join
"mavrick_101" wrote:
> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||>> Full outer join (* = *)
' I doubt if it was there.
Anith|||Thanks Anith.
AMB
"Anith Sen" wrote:
> ' I doubt if it was there.
> --
> Anith
>
>
No comments:
Post a Comment