This content was proof-read by Grammarly. You can Try Grammary for FREE
There are couple of ways in which you can retreive the version of the SQL Server using T-SQL.
Checking the version of a SQL Server using T-SQL
1. using @@VERSION
2. Using SERVERPROPERTY function as shown
SELECT SERVERPROPERTY('productversion') as version, SERVERPROPERTY('productlevel') as level, SERVERPROPERTY('edition') as edition
Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.