Global Variables in Sql server

Global Variables:

•   These are available in sql server and predefined.
•  we can't modify these variables.
• these are helpful in transact sql
• These start with @@
• The server maintains these values in variables

• Example

   Collapse | Copy Code

  SELECT @@MAX_CONNECTIONS AS 'Max Connections'

  Output

   Collapse | Copy Code

  Max Connections
  ---------------
  32767