版本資訊:
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