Checking the version of a SQL Server using T-SQL


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

SELECT @@VERSION
image

2. Using SERVERPROPERTY function as shown

SELECT SERVERPROPERTY('productversion') as version, SERVERPROPERTY('productlevel') as level,
SERVERPROPERTY('edition') as edition
image
Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

Newsletter Signup

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

%d bloggers like this: