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 free online test on SQL Server

Responses


 (Getemail alerts when others member replies)

More available Categories:








The worst disability in life is a bad attitude.
-SupaNova Slom