|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
20/05/2008, 23h27
|
#1 |
Messages: n/a
Hébergeur: |
SQLOperator\Join
We are converting some queries that were used in SQL Server 2000 to SQL
Server 2005. They have a where clause like below: where personid *= recv.personid What is the *= an OuterJoin? TIA |
|
|
21/05/2008, 00h52
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: SQLOperator\Join
> where personid *= recv.personid
> > What is the *= an OuterJoin? Yes, "*=" is deprecated syntax for a LEFT OUTER JOIN. -- Hope this s. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/ "gh" <gh@att.net> wrote in message news:%23gQXuisuIHA.524@TK2MSFTNGP05.phx.gbl... > We are converting some queries that were used in SQL Server 2000 to SQL > Server 2005. They have a where clause like below: > > where personid *= recv.personid > > What is the *= an OuterJoin? > > TIA |
|
|
 |
| Outils de la discussion | |
|
|
