How to Get SQL Server Version ?

 Posted by Syedshakeer on 8/24/2009 | Category: Sql Server Interview questions | Views: 5141
Answer:

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


The information returned by @@VERSION is similar to the product name, version, platform, and file data returned by the xp_msver stored procedure, which provides more detailed information.

SELECT @@VERSION


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response