July 10, 2007 at 3:41 pm
I recently came across this in a stored procedure
...where ... and FieldX *= FieldY...
I cannot seem to find anything about *= in online help, or internet searches. Could I get a brief explanation?
Thanks in advance
July 10, 2007 at 4:04 pm
It is an obsolete syntax for doing a left join.
July 10, 2007 at 4:47 pm
Great! Thanks!
July 11, 2007 at 12:09 am
These syntax is not supported in SQL 2005. Yo have to use only ANSI syntax in 2005 and you will not get expected results with these.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 11, 2007 at 2:39 pm
Not *entirely* correct.
IF you run your DB in compatibility level 80 you can still use that syntax.
* Noel
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply