5 out of 6 rated this helpful - Rate this topic

System Functions (Transact-SQL)

SQL Server 2008

The following functions perform operations on and return information about values, objects, and settings in SQL Server.

The Transact-SQL system functions and their determinism property are listed in the following table. For more information about function determinism, see Deterministic and Nondeterministic Functions.

Function	Determinism
APP_NAME	Nondeterministic
CASE expression	Deterministic
CAST and CONVERT	Deterministic unless used with datetime, smalldatetime, or sql_variant.
COALESCE	Deterministic
COLLATIONPROPERTY	Nondeterministic
COLUMNS_UPDATED	Nondeterministic
CURRENT_TIMESTAMP	Nondeterministic
CURRENT_USER	Nondeterministic
DATALENGTH	Deterministic
@@ERROR	Nondeterministic
ERROR_LINE	Nondeterministic
ERROR_MESSAGE	Nondeterministic
ERROR_NUMBER	Nondeterministic
ERROR_PROCEDURE	Nondeterministic
ERROR_SEVERITY	Nondeterministic
ERROR_STATE (Transact-SQL)	Nondeterministic
fn_helpcollations	Deterministic
fn_servershareddrives	Nondeterministic
fn_virtualfilestats	Nondeterministic
FORMATMESSAGE	Nondeterministic
GETANSINULL	Nondeterministic
HOST_ID	Nondeterministic
HOST_NAME	Nondeterministic
IDENT_CURRENT	Nondeterministic
IDENT_INCR	Nondeterministic
IDENT_SEED	Nondeterministic
@@IDENTITY	Nondeterministic
IDENTITY (Function)	Nondeterministic
ISDATE	Nondeterministic
ISNULL	Deterministic
ISNUMERIC	Deterministic
NEWID	Nondeterministic
NULLIF	Deterministic
PARSENAME	Deterministic
ORIGINAL_LOGIN	Nondeterministic
@@ROWCOUNT	Nondeterministic
ROWCOUNT_BIG	Nondeterministic
SCOPE_IDENTITY	Nondeterministic
SERVERPROPERTY	Nondeterministic
SESSIONPROPERTY	Nondeterministic
SESSION_USER	Nondeterministic
STATS_DATE	Nondeterministic
sys.dm_db_index_physical_stats (Transact-SQL)	Nondeterministic
SYSTEM_USER	Nondeterministic
@@TRANCOUNT	Nondeterministic
UPDATE()	Nondeterministic
USER_NAME	Nondeterministic
XACT_STATE	Nondeterministic

Reference

Functions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD