SQL Server Articles

Submit Article
Home » Articles » SQL Server » Configuration FunctionsRSS Feeds


Posted By: Sarita Patel     Category: SQL Server     Views: 1391

This article explains about @@VERSION function in sql server with examples.

@@VERSION function returns date, version, and processor type for the current installation of SQL Server.

Syntax of @@VERSION Function :


Return type of @@VERSION function is nvarchar.

Examples of @@VERSION Function :

Example 1 : Use of @@VERSION function in select clause


Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)   May 26 2000 14:24:20   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 6.0 (Build 6002: Service Pack 2) 

Above example returns installed sql server information.

Didn't find what you were looking for? Find more on @@VERSION - VERSION Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of @@VERSION - VERSION Function is from United States.
View All Articles

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!