Learn T-SQL Commands with Samples
Skip Navigation Links
Skip Navigation Links.
Expand DatabaseDatabase
Expand TableTable
Expand ViewView
Expand Stored ProcedureStored Procedure
Expand Data FilteringData Filtering
Expand Data GroupingData Grouping
Expand JoinsJoins
Expand TriggerTrigger
Expand CursorCursor
Expand OperatorsOperators
Expand ConstraintsConstraints
Collapse FunctionsFunctions
Expand Conditional ProcessingConditional Processing
Expand LoopingLooping
Expand Error HandlingError Handling
Expand v.IMP Queriesv.IMP Queries
Expand XMLXML
Expand Query PerformanceQuery Performance
Expand QueriesQueries
Expand NormalizationNormalization
Expand CreateCreate
     

Configuration Functions

  
SELECT

      @@SERVICENAME     as	'ServiceName',
      @@OPTIONS         as	'Options',
      @@LANGUAGE        as	'Language',
      @@VERSION         as	'Version',
      @@LANGID          as	'LangID',
      @@SERVERNAME      as	'ServerName',
      @@LOCK_TIMEOUT    as	'LockTimeout',
      @@SPID            as	'SPID',
      @@MAX_CONNECTIONS as	'MaxConnections',
      @@TEXTSIZE        as	'TextSize',
      @@MAX_PRECISION   as	'MaxPrecision',
      @@NESTLEVEL       as	'NestLevel',
      @@REMSERVER       as	'RemServer',
      @@DBTS            as	'DBTS'
    
      

      
Output


      

      ServiceName
      Options
      Language
      Version
      LangID
      ServerName
      LockTimeout
      SPID
      MaxConnections
      TextSize
      MaxPrecision
      NestLevel
      RemServer
      DBTS
      


      

      MSSQLSERVER
      5496
      us_english
      Microsoft SQL Ser.....
      0
      FiLastname
      -1
      54
      32767
      2147483647
      38
      0
      NULL
      0x00000000000007D0