Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2010-05-06 : 13:33:39
|
| Ran this in SQL Server 2k5SELECT * FROM CLIENT c, CLIENT_FUNCTIONS fWHERE c.Process_Id =* f.Process_IdMsg 4147, Level 15, State 1, Line 2The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.In 2000SELECT * FROM Orders o, [Order Details] dWHERE o.OrderID =* d.OrderIDIt worksIs it completely depricated in 2k8?Personally I ALWAYS used ANSI SQL...but we are doing a masive migration of everything to 8Should be funBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
=*