amy26 (4/2/2013)
GilaMonster (4/2/2013)
amy26 (4/2/2013)
I'm really bummed about this cause now I can't use some of the new features of SQL 2008 :angry:Why not?
Comparability level doesn't disable new features, it just changes how the query execution engine handles some constructs and whether some forms of SQL are valid or not.
Well, for example... I wrote a stored procedure that uses PIVOT and I cannot run this procedure when the compatibility mode is set to 80. It will only work if its set to 100.
Yes, Pivot is the exception, along with CROSS APPLY iirc. Most of the other new features work fine regardless of compat mode.
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