Logo 
Search:

SQL Server Articles

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

@@VERSION - VERSION Function

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

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 :

@@VERSION

Return type of @@VERSION function is nvarchar.



Examples of @@VERSION Function :

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

SELECT @@VERSION

Output
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.
  
Share: 


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!