Global variables play a very important role in SQL server. Which are very effective to use in our regular Transact-SQL. In my article I am trying to describe it in a simple architecture.
Global variables represent a special type of variable. The server always maintain the values of these variables. All the global variables represent information specific to the server or a current user session.
Global variable names begin with a @@ prefix. You do not need to declare them, since the server constantly maintains them. They are system-defined functions and you cannot declare them.
Some example of commonly used global variable are mentioned bellow.
- @@TOTAL_READ / @@TOTAL_WRITE
SELECT @@VERSION [SQL SERVER VERSION]
For better understanding of each global variable please refer to MSDN or MS Related document.
I think the information is quite informative and thanking you to provide your valuable time on it.
Posted by: MR. JOYDEEP DAS