In SQL Server, which of the following SQL queries will show the currently installed version of SQL?

In SQL Server, which of the following SQL queries will show the currently installed version of SQL?

• Select version from @@version
• @@version
• Show @@version
• Select @@version 

EXPLANATION

Variables starting @@ are system variables. You need a select to be able to return the value, so the answer is "Select @@version". The other three answers are nonsense, as far as SQL is concerned.

SOURCE

https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/