Does SQL 2005 still support the *= syntax?

Does SQL Server 2005 still support the *= outer join syntax without having
to set the DB Compatibility switch? A friend of mine tested out SQL 2005
Beta 2 and said that *= was still supported, but then when the official SQL
2005 release came out, *= no longer worked without having to set the
compatibility switch. That seems like a HUGE change to make between the
last beta and the official release.AFAIK, this change was made around the June CTP timeframe. The answer is
no, there is no support for *= unless you're in 8.0 compatability mode (or
lower). Which, IMHO, is a great thing. That syntax has caused so many
problems over the years...
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Jay Sullivan" <jaysullivan@.nospam.nospam> wrote in message
news:e42BOS74FHA.2560@.TK2MSFTNGP12.phx.gbl...
> Does SQL Server 2005 still support the *= outer join syntax without having
> to set the DB Compatibility switch? A friend of mine tested out SQL 2005
> Beta 2 and said that *= was still supported, but then when the official
> SQL 2005 release came out, *= no longer worked without having to set the
> compatibility switch. That seems like a HUGE change to make between the
> last beta and the official release.
>