SQL Server(mssql) 버전 확인

SQL Server(mssql) 데이터베이스 버전 확인

---

SQL

SQL> SELECT @@VERSION;                                                                                                                                                                                       |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Microsoft SQL Server 2022 (CTP2.0) - 16.0.600.9 (X64) ¶ May 20 2022 13:29:42 ¶ Copyright (C) 2022 Microsoft Corporation¶ Developer Edition (64-bit) on Linux (Ubuntu 20.04.4 LTS) <X64>|


SQL> 
SELECT
    CAST(SERVERPROPERTY('ProductVersion') AS SYSNAME) AS ProductVersion,
    CAST(SERVERPROPERTY('ProductLevel') AS SYSNAME)   AS ProductLevel,
    CAST(SERVERPROPERTY('Edition') AS SYSNAME)        AS Edition,
    CAST(SERVERPROPERTY('EngineEdition') AS INT)      AS EngineEdition
    
ProductVersion|ProductLevel|Edition                   |EngineEdition|
--------------+------------+--------------------------+-------------+
16.0.600.9    |CTP2.0      |Developer Edition (64-bit)|            3|

 

Command

mssql@dceabdf04062:/opt/mssql-tools/bin$ /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "암호" -Q "SELECT @@VERSION"

---

---