Install SQL Server 2019 on Windows Server 2019: 安裝抓圖

版本資訊：
SQL Server 2019 RTM - 15.0.2070.41 (X64)

Build Information	Note
SQL Server Version	SQL Server 2019
Product Version	15.0.2070.41
Product Level	RTM
Product Edition	Enterprise Edition (64-bit)
Database Internal Version	904

SQL Server 2019 的圖型介面工具：SSMS、SSDT，需要額外下載安裝。

---

版本資訊

-- 01_SQL Server 2019 + Windows Server 2019

-- 02_資料庫相容性層級：150

---

安裝抓圖

Install SQL Server 2019 on Windows Server 2019

https://photos.app.goo.gl/TwioHWoq2GrKnbpBA

---

Query version, edition and update level 

V2: Query SQL Server system and build information

適用於 SQL Server 2019
加上 作業系統平台
使用 SQL Server 2017 新增加的 sys.dm_os_host_info

-- V2_SQL Server system and build information
-- Applies to: SQL Server 2019
  
SELECT @@SERVERNAME 'InstanceName',
 CASE WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '8%' THEN 'SQL Server 2000'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '9%' THEN 'SQL Server 2005'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.0%' THEN 'SQL Server 2008'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.5%' THEN 'SQL Server 2008 R2'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '11%' THEN 'SQL Server 2012'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '12%' THEN 'SQL Server 2014'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '13%' THEN 'SQL Server 2016'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '14%' THEN 'SQL Server 2017'
  WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '15%' THEN 'SQL Server 2019'
  ELSE 'unknown'
  END AS 'SQLServerVersion ', 
 CASE WHEN SERVERPROPERTY('IsClustered') = 1 AND SERVERPROPERTY('IsHadrEnabled') = 1 THEN 'Failover Cluster + Availability Groups'
  WHEN SERVERPROPERTY('IsClustered') = 1 THEN 'Failover Cluster'
  WHEN SERVERPROPERTY('IsHadrEnabled') =1 THEN 'Availability Groups'
  ELSE 'unknown'
 END AS 'High-Availability', 
 host_distribution 'HostDistribution', host_release 'HostRelease',
 SERVERPROPERTY('ProductVersion') 'ProductVersion',
 SERVERPROPERTY('ProductLevel') 'ProductLevel',
 SERVERPROPERTY('Edition') 'ProductEdition',
 SERVERPROPERTY('ProductUpdateLevel') 'ProductUpdateLevel', 
 SERVERPROPERTY('ProductBuildType') 'ProductBuildType', 
 SERVERPROPERTY('ProductUpdateReference') 'ProductUpdateReference', 
 DATABASEPROPERTYEX('master','Version') 'DatabaseInternalVersion'
FROM sys.dm_os_host_info 
GO

---

Reference

Install SQL Server 2017 on Windows Server 2016
https://sharedderrick.blogspot.com/2017/10/install-sql-server-2017-on-windows.html

[SQL Server] Query version, edition and update level - 版本、版次、編號
https://sharedderrick.blogspot.com/2017/08/sql-server-query-version-edition-and.html