🎴 Flashcard Mode

SQL Server and Sybase ASE Database Concepts

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Which of the below commands is used to find more information about the SQL Server installed such as edition, product level etc. ?

AnswerClick to flip back
A
select @@version
💡 Explanation:

The @@version global variable returns complete version information including edition, product level (RTM, SP, CTP), and build number. The other options are either non-existent stored procedures or return server configuration rather than version details.

Change Mode