How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

by 
select name, compatibility_level , version_name = 
CASE compatibility_level
    WHEN 65  THEN 'SQL Server 6.5'
    WHEN 70  THEN 'SQL Server 7.0'
    WHEN 80  THEN 'SQL Server 2000'
    WHEN 90  THEN 'SQL Server 2005'
    WHEN 100 THEN 'SQL Server 2008/R2'
    WHEN 110 THEN 'SQL Server 2012'
    WHEN 120 THEN 'SQL Server 2014'
    WHEN 130 THEN 'SQL Server 2016'
    WHEN 140 THEN 'SQL Server 2017'
    WHEN 150 THEN 'SQL Server 2019'
    ELSE 'new unknown - '+CONVERT(varchar(10),compatibility_level)
END
from sys.databases

More Related Contents:

  1. T-SQL SEQUENCE runs out, no cycle, what happens?
  2. Max Nbr of Months W/ No Activity in Past 12 Months
  3. SQL server query to output the data shown below
  4. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  5. How do I generate a random number for each row in a T-SQL select?
  6. Select columns from result set of stored procedure
  7. Combine multiple results in a subquery into a single comma-separated value
  8. Pass Dictionary to Stored Procedure T-SQL
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. Floor a date in SQL server
  11. How to drop a table if it exists?
  12. Create a view with ORDER BY clause
  13. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  14. INSERT INTO vs SELECT INTO
  15. Possible to store value of one select column and use it for the next one?
  16. How FOR XML PATH(”) works when concatenating rows
  17. Scheduled run of stored procedure on SQL server
  18. SQL Server ORDER BY date and nulls last
  19. How to check if a database exists in SQL Server?
  20. SQL Server variable columns name?
  21. How can I do something like: USE @databaseName
  22. What is the Oracle equivalent of SQL Server’s IsNull() function?
  23. How to split string and insert values into table in SQL Server
  24. SQL Recursive CTE: Finding objects linked by property
  25. PRINT statement in T-SQL
  26. T-sql – determine if value is integer
  27. Convert decimal time to hours and minutes
  28. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  29. Is there an “IF EXISTS” test for a linked server?
  30. SQL Server stored procedure return code oddity

Leave a Comment