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

No comments:

Post a Comment