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 |
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
 Posted - 2010-05-04 : 07:29:21
|
| I dont know whether this is the right place to post or not but anyways -I set the compatibility of sql server 2005 to 2000 then now if i am running the query which is only compatible to 2005 then it should not work now as the compatiblity mode is sql server 2000for example row_number function is not available in sql 2000then it should not worked but it works...Vaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-04 : 08:03:54
|
Yes it works, that is normal.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-04 : 08:10:19
|
But this should not work without level 80:select * from(select 1 as id, 'test1' as xy)dt1,(select 1 as id, 'test1' as xy union all select 2,'test2')dt2where dt1.id =* dt2.id
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-05-04 : 09:31:37
|
| Okey I got it... ThanksVaibhav TTo walk FAST walk ALONE To walk FAR walk TOGETHER |
|
|
|
|
|
|
How to run query with compatibility of 2000