組態函數 (Transact-SQL)Configuration Functions (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

這些純量函數會傳回目前組態選項設定的相關資訊:These scalar functions return information about current configuration option settings:

@@DATEFIRST@@DATEFIRST @@OPTIONS@@OPTIONS
@@DBTS@@DBTS @@REMSERVER@@REMSERVER
@@LANGID@@LANGID @@SERVERNAME@@SERVERNAME
@@LANGUAGE@@LANGUAGE @@SERVICENAME@@SERVICENAME
@@LOCK_TIMEOUT@@LOCK_TIMEOUT @@SPID@@SPID
@@MAX_CONNECTIONS@@MAX_CONNECTIONS @@TEXTSIZE@@TEXTSIZE
@@MAX_PRECISION@@MAX_PRECISION @@VERSION@@VERSION
@@NESTLEVEL@@NESTLEVEL

所有組態函數的運算結果充滿不確定性。All configuration functions operate in a nondeterministic way. 換言之,這些函數並非每次呼叫時,都會傳回相同的結果,即便使用同一組輸入值也是如此。In other words, these functions do not always return the same results every time they are called, even with the same set of input values. 如需函式確定性的詳細資訊,請參閱決定性和非決定性函式See Deterministic and Nondeterministic Functions for more information about function determinism.

另請參閱See also

函式 (Transact-SQL)Functions (Transact-SQL)