SQL Server, PIVOT, Compatibility Level
If you want to use SQL Server Operators Operators like PIVOT, UNPIVOT, NTILE, and CTE's
you'll probaly recieve follwoing error message:
"Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel. (.Net SqlClient Data Provider)" You have to set your database to 90 compatibility to use the SQL 2005 operators like PIVOT, UNPIVOT, NTILE, and CTE's. To do this you just need to execute the following statement:
EXEC dbo.sp_dbcmptlevel @dbname=N'DatabaseName', @new_cmptlevel=90
Just change the databasename to match your database.
"Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel. (.Net SqlClient Data Provider)" You have to set your database to 90 compatibility to use the SQL 2005 operators like PIVOT, UNPIVOT, NTILE, and CTE's. To do this you just need to execute the following statement:
EXEC dbo.sp_dbcmptlevel @dbname=N'DatabaseName', @new_cmptlevel=90
Just change the databasename to match your database.
Tags
Comments
Write the first comment
Leave a trace
Post being viewed right now
