Saturday, August 2, 2014

SQL Server


ALTER DATABASE Compatibility Level (Transact-SQL) (Ex: Enable pivot table)

ALTER DATABASE database_name 
SET COMPATIBILITY_LEVEL = 100


Note: 



        80 = SQL Server 2000 



        90 = SQL Server 2005 



        100 = SQL Server 2008 and SQL Server 2008 R2


        110 = SQL Server 2012




















Posted by



at







































No comments:















Post a Comment


















        

      









Subscribe to:
Post Comments (Atom)