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








Few things a doctor does are more important than relieving pain. . . pain is soul destroying. No patient should have to endure intense pain unnecessarily. The quality of mercy is essential to the practice of medicine here, of all places, it should not be strained.
-Marcia Angell