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 |
|
btrimpop
Posting Yak Master
214 Posts |
 Posted - 2008-08-20 : 16:20:33
|
| Hi All,Does anyone know if 2008 still supports the old T-SQL join syntax or has it switched completely to ANSI?Thanks"In theory there is no difference between theory and practice. But in practice there is!" |
|
|
btrimpop
Posting Yak Master
214 Posts |
Posted - 2008-08-20 : 16:40:07
|
Never mind! Looks like you can set the compatiblity level to SQL 2000 which still supports T-SQL joins. So I don't have to rewrite queries in that ancient legacy app just yet!  (assuming the SQL 2000 compatibility works right of course!  "In theory there is no difference between theory and practice. But in practice there is!" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-20 : 16:51:21
|
Doing that also restricts you from using all the new Windowed functions.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
btrimpop
Posting Yak Master
214 Posts |
Posted - 2008-08-20 : 16:58:03
|
quote:
Originally posted by Peso
Doing that also restricts you from using all the new Windowed functions.
E 12°55'05.25"N 56°04'39.16"
I know, but with that ancient legacy app it's not an issue! I just don't want to have to spend days/weeks at this point rewriting/testing queries! Yeah lazy me!"In theory there is no difference between theory and practice. But in practice there is!" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-20 : 17:22:43
|
Then why upgrade at all?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
btrimpop
Posting Yak Master
214 Posts |
Posted - 2008-08-21 : 09:58:38
|
| Unfortunately, not my decision."In theory there is no difference between theory and practice. But in practice there is!" |
|
|
|
|
|
|
T-SQL Join Syntax and SQL 2008