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








No, this is not the beginning of a new chapter in my life this is the beginning of a new book! That first book is already closed, ended, and tossed into the seas this new book is newly opened, has just begun! Look, it is the first page! And it is a beautiful one!
-C. JoyBell C.