How to get your version of SQL Server
I have been using SQL server for more years than I care to remember, all the way from SQL Server 2005 to SQL Server 2016 that im using for intermittentbug.com.
Microsoft release many different editions such as Express, Web, Standard, Datacentre, not to mention the updated revision such as R2.
It’s important to know the exact version of SQL server you are working with as compatibility among the different editions and new releases can be limited, plus new features of TSQL are available in the newer version which may not be compatible with older editions.
To get the version of SQL server follow these simple steps…
select @@version AS SQLServer_Version
this returns the following when i run on my local machine
Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 2016 23:23:58 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Enterprise N 6.3 <X64> (Build 14393: )