How to check SQL Server version from T-SQL in SQL Server?

Options :
  1. SELECT @VERSION
  2. SELECT @@VERSION
  3. SELECT @@VERSION_NO
  4. SELECT @@VERSION_NUMBER
Answer and Explanation :-

Answer: Option 2

Explanation:

@@VERSION is the SQL SERVER global variable to check the running version of SQL SERVER. syntax

SELECT @@VERSION

How do you rate this queston?  Very Easy  Easy  Average  Above Average  Tough

Previous Question : DROP command in SQL Server falls under what type of command?

Next Question : COMMIT command in SQL Server comes under which type of command?

Click here for online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:-








Success is achieving your goals and objectives with happiness, love and glory
-Nabil Basma