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 |
|
urzsuresh
Starting Member
30 Posts |
 Posted - 2010-12-22 : 05:34:54
|
Hi Friends, Earlier days we using sql2000,from this server we using mostly Inline query (for join operation)Eg. we using Join Operation as*= and =* Above one is The current compatibility level is 80.Later on we migrate the db to sql2005.Here we change the compatibilty levet to 90.In this version we use lot of pivot concept.But here compatibilty levet to 80(Join operation) is not supported.Can any one please guide me, how to adapt both in one compatible level.Problem is, we cant change existing join opertaion. because we used around 250 place in my application.Please guide me, i dont know what do to.Suri |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-22 : 05:41:21
|
| "Problem is, we cant change existing join opertaion. because we used around 250 place in my application"I don't think you have any choice. The "*=" and "=*" syntax has been deprecated since SQL 7 I think ... and stopped being supported in SQL 2005 - so to use any features added to SQL from SQL 2005 onwards you will have to change the code.Compatibility Migration Hints and Tips: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-22 : 05:58:41
|
| I beleive the old ANSI89 joins "*=" and "=*" are depreciated from SQL 2005 while the ANSI89 equivalent inner join(where a.id=b.id) is still supported in SQL2008 and even in CTP version of Denali i.e SQL Server 2011.PBUH |
|
|
|
|
|
|
Compatibilty issue.can please guide