System Functions (Transact-SQL)

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

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

Nondeterministic

SYSTEM_USER

Nondeterministic

@@TRANCOUNT

Nondeterministic

UPDATE()

Nondeterministic

USER_NAME

Nondeterministic

XACT_STATE

Nondeterministic

See Also

Reference

Functions (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance