What is @@Version in Sql Server?

Returns version, processor architecture, build date, and operating system for the current installation of SQL Server.

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

SELECT @@VERSION AS 'SQL Server Version'

No comments: