Programming in MS SQL Server 2012

Configuration Functions


Function @@LANGID
Description Returns the local language identifier (ID) of the language currently in use.
Example SELECT @@LANGID AS 'Language ID'
Result 0

* * * * *

Function @@LANGUAGE
Description Returns the name of the language currently in use.
Example SELECT @@LANGUAGE AS 'Language Name'
Result us_english

* * * * *

Function @@MAX_CONNECTIONS
Description Returns the maximum number of simultaneous user connections allowed on a Microsoft SQL Server.
Example SELECT @@MAX_CONNECTIONS
Result 32767

* * * * *

Function @@SERVERNAME
Description Returns the name of the local server running Microsoft SQL Server.
Example SELECT @@SERVERNAME
Result Data-e-Education

* * * * *

Function @@VERSION
Description Returns the date, version, and processor type for the current installation of Microsoft SQL Server.
Example SELECT @@VERSION
Result Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

* * * * *

Email Your Comment To AUTHOR

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.