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 |
|
PurpleSun
Yak Posting Veteran
50 Posts |
 Posted - 2007-01-26 : 13:50:49
|
| Hi All,I've just started with SQL Server 2005 and I wonder if I can find somewhere a list of constructs and syntax items that worked in SQL 2000, but not in SQL 2005. For instance Tsql joins (*=) are no longer supported in SQL 2005, only ansi joins (left join).Thanks in advance. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-26 : 17:15:33
|
| Take a look at the tables in the docs for the sp_dbcmptlevel stored proc (the second table, titled "Differences Between Lower Compatibility Levels and Level 90" is probably more what you want than the first one which has things that changed from 6.5 to 7.0)Online here http://msdn2.microsoft.com/en-us/library/ms178653.aspx |
 |
|
|
|
|
|
SQL constructs and syntax