Databases Reference
In-Depth Information
Configuration
Variable Name
Return Type
Description
Returns the system setting for the first day of the week.
1 = Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday,
5 = Friday, 6 = Saturday, 7 = Sunday. U.S. default is 7.
@@DATEFIRST
TinyInt
The last assigned unique
TimeStamp
value.
@@DBTS
VarBinary
The current language ID for the server.
(US English = 0, German = 1, French = 2, and so on).
@@LANGID
SmallInt
The current language string for the server. Returns the
language name in the native language form (US_English,
Deutsch, Français, Dansk, Español, Italiano, and so on).
@@LANGUAGE
nVarChar
Lock timeout setting for the current session in
milliseconds.
@@LOCK_TIMEOUT
Int
The maximum concurrent connections setting for the
server.
@@MAX_CONNECTIONS
Int
The maximum precision setting for decimal and numeric
types. Default is 38 significant digits (total to the left and
right of the decimal point).
@@MAX_PRECISION
TinyInt
Returns an internal tracking number used by product
development and support groups at Microsoft.
@@MICROSOFTVERSION
Int
The current number of nested stored procedure or
trigger calls. This may be used to limit cascading and/or
recursive calls prior to reaching the system limit of 32
recursive calls.
@@NESTLEVEL
Int
The set of query-processing options for the current user
session. Multiple options are combined mathematically
using bitwise addition (that is, If
SELECT @@OPTIONS &
(512 + 8192) > 0 ...
). Any combination of option
values may be added to determine whether all these
options are enabled.
@@OPTIONS
Int
Search WWH ::
Custom Search