February 18, 2010 at 2:15 am
hi All
How to Find the compatibility Level of the Storedprocedure/Functions.
I mean If i Create a Stored Procedure Using Date DateType or Merge
or Grouping Sets That procedure Will work Only in SQL 2008 , if i Used
CTE in Storedprocedure that will work in SQL2005/SQL2008 .Like i
Need to List The Stored Procedure Which will execute Only in SQL2008
Is There Any way To do This.
Thanks
Deepak.A
February 18, 2010 at 6:39 am
Not as far as I know, no.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
February 18, 2010 at 7:56 am
Once upon a time, developers were concerned about developing with an eye toward backward compatability and cross-platform compatability. I don't see that much anymore.
There is no way to tell.
February 18, 2010 at 9:24 am
Steve Cullen (2/18/2010)
Once upon a time, developers were concerned about developing with an eye toward backward compatability and cross-platform compatability. I don't see that much anymore.
Why would I restrict myself to only SQL 2000 features when working on SQL 2008, just in case someone happened to want to move the DB back to SQL 2000? Cross platform's find for vendors who want to sell products that work everywhere, but those are not the majority of systems.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2010 at 9:45 am
Sorry. Didn't mean to sound nostalgic 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply