August 1, 2012 at 8:22 am
Does SQL Server 2008 and higher version supports *= operator of Joins?
August 1, 2012 at 8:24 am
This is a very old fashioned syntax.
You should use LEFT OUTER JOIN ON ......, RIGHT OUTER JOIN ON ...... etc.
August 1, 2012 at 8:27 am
Boby B Jacob (8/1/2012)
Does SQL Server 2008 and higher version supports *= operator of Joins?
2008 does in 80 compat mode. 2012 does not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 8:28 am
Boby B Jacob (8/1/2012)
Does SQL Server 2008 and higher version supports *= operator of Joins?
You can find a list of features deprecated/being deprecated, in versions of SQL Server, here: http://msdn.microsoft.com/en-us/library/ms143729(v=sql.90).aspx
Use the Other Versions drop-down to pick the version to look at.
SQL 2008 and 2008 R2 list "*=" and "=*" as "next version of database will deprecate", on that page.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply