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


Are you a .NET Developer planning to integrate GraphQL for .NET in your Application? Check out this book
SELECT @@VERSION
image

2. Using SERVERPROPERTY function as shown

SELECT SERVERPROPERTY('productversion') as version, SERVERPROPERTY('productlevel') as level,
SERVERPROPERTY('edition') as edition
image
%d bloggers like this: