The compatibility level of a SQL Server database matters since the T-SQL code from a higher compatibility level will not work in a database with lower compatibility level.
How to find compatibility level?
Launch SQL Server Management Studio and pick the database for which you want to find the compatibility level.
Right click the database node for the database TestPubs. From the drop-down pick Properties. In the properties page click Options and you will find the compatibitlity level as shown. This is for SQL Server 2012.
SQL Server 2017: The compatibility level for Northwind (SqlServer 2008(100) restored from a backup file from CodePlex site is the following:
No comments:
Post a Comment