Languages
Wiki
All Wiki Articles Create Wiki Article
version
sql-server
mssql
sql
query
programming
[Edit]
EN

MS SQL Server - check version using SQL

2 contributors
7 contributions
0 discussions
0 points
Created by:
Huzaifa-Ball
475

In this short article, we would like to show how to check the MS SQL Server version using SQL.

Quick solution:

SELECT @@VERSION

Example output:

Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)   Sep 24 2019 13:48:23   Copyright (C) 2019
Microsoft Corporation  Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 19042: )
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Direct link
Join to our subscribers to be up to date with content, news and offers.

MS SQL Server - problems

MS SQL Server - CREATE TABLE IF NOT EXIST equivalent
MS SQL Server - Create or alter view
MS SQL Server - Create table with FOREIGN KEY
MS SQL Server - Create view if not exist
MS SQL Server - Drop table if exists
MS SQL Server - Drop view if exists
MS SQL Server - GROUP BY multiple columns
MS SQL Server - Insert NULL values
MS SQL Server - Select from view
MS SQL Server - UPDATE query with FETCH
MS SQL Server - Update all rows
MS SQL Server - Update multiple rows at once
MS SQL Server - add FOREIGN KEY to existing table
MS SQL Server - add column to existing table
MS SQL Server - average value for grouped rows
MS SQL Server - calculate average of column values and display the result with no decimals
MS SQL Server - check version using SQL
MS SQL Server - concatenate multiple columns into one
MS SQL Server - concatenate multiple rows into one field
MS SQL Server - convert value to CHAR (using CAST() function)
MS SQL Server - convert value to CHAR (using CONVERT() function)
MS SQL Server - count distinct values
MS SQL Server - count duplicated rows
MS SQL Server - count rows with NULL values
MS SQL Server - delete all duplicated rows except one
MS SQL Server - delete row where column is empty string (blank)
MS SQL Server - delete row where column is null
MS SQL Server - duplicate table link---
MS SQL Server - find duplicated values
MS SQL Server - find duplicated values in multiple columns
MS SQL Server - find first row
MS SQL Server - find row with null value in column
MS SQL Server - find row with null value in one of many columns
MS SQL Server - find rows where column is empty string (blank)
MS SQL Server - make column values unique
MS SQL Server - max value for grouped rows
MS SQL Server - minimum value for grouped rows
MS SQL Server - search for NULL values in multiple columns
MS SQL Server - select first N rows
MS SQL Server - select last N rows
MS SQL Server - select last row
MS SQL Server - select rows with max value of column
MS SQL Server - sort in ascending or descending order
MS SQL Server - sum value for grouped rows
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join