Thursday, 2 February 2012

Global variables

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.



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