SQL Server @@Version

SQL Server @@Version is a configuration function that returns system and build information for the current installation of SQL Server.

SYNTAX

@@Version

Return Type of @@Version is nvarchar.

Using @@Version to display the current version of SQL Server 

Following statement uses @@Version function to return the current version of SQL Server.

SELECT @@VERSION

As you can see, it returns the completer system and build information for the current installation of SQL Server.

Also Read..

SQL Server @@SPID

SQL Server @@Language