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