Pages

Wednesday, February 25, 2009

How to Get SQL Server Version

@@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

No comments: