We can find out the version of SQL server using query. The @@version query will returns all about the SQL server versions. Once you run the query you will get the following information about SQL server.
- SQL server Version.
- Processor Architecture.
- SQL server Build Date.
- Copyright Details.
- SQL server Edition Details.
- OS version.
SELECT @@VERSION
-----------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2017 (RTM-CU14) (KB4484710) - 14.0.3076.1 (X64)
Mar 12 2019 19:29:19
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)