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:-








I am billionaire bold bright omnipotent lively determined to go within to win opening my omnific eyes to realize wisdom innovation naturalizes.My cascading flow of financial love lavishly streams gold bars as I realize gold is intrinsic wealth as my intuitive imagination is my intrinsic innovations.
-Robert A. Wilson Holiday Wisdom