Find the SQL server Version

             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)






No comments:

Post a Comment