Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

--- hobby:development:sql:select:sys_0003 [2023/08/30 11:46] – mauro.cortese
+++ hobby:development:sql:select:sys_0003 [2023/11/13 21:07] (versione attuale) – mauro.cortese
@@ Linea 8: / Linea 8: @@
     db.database_id ID,
     db.name DBName,
-	mf.name LogicalName,
+    mf.name LogicalName,
     mf.type_desc FileType,
     mf.Physical_Name Path,
-	mf.size Size,
+    mf.size Size,
-	db.collation_name Collation,
+    db.collation_name Collation,
-	db.recovery_model_desc RecMode
+    db.recovery_model_desc RecMode,
+	CompatibilityLevel = CASE db.compatibility_level
+						    WHEN 65  THEN 'SQL Server 6.5 (65)'
+						    WHEN 70  THEN 'SQL Server 7.0 (70)'
+						    WHEN 80  THEN 'SQL Server 2000 (80)'
+						    WHEN 90  THEN 'SQL Server 2005 (90)'
+						    WHEN 100 THEN 'SQL Server 2008/R2 (100)'
+						    WHEN 110 THEN 'SQL Server 2012 (110)'
+						    WHEN 120 THEN 'SQL Server 2014 (120)'
+						    WHEN 130 THEN 'SQL Server 2016 (130)'
+						    WHEN 140 THEN 'SQL Server 2017 (140)'
+						    WHEN 150 THEN 'SQL Server 2019 (150)'
+						    WHEN 160 THEN 'SQL Server 2022 (160)'
+						    ELSE 'new unknown - ' + CONVERT(varchar(10),compatibility_level)
+							END
 FROM
     sys.master_files mf
@@ Linea 19: / Linea 33: @@
     master.sys.databases db ON db.database_id = mf.database_id
 WHERE db.database_id > 4
-	ORDER BY DBName, FileType
+    ORDER BY DBName, FileType
 </sxh>