System Functions

statements

#tsql#statements

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

$PARTITION

ERROR_PROCEDURE

@@ERROR

ERROR_SEVERITY

@@IDENTITY

ERROR_STATE

@@PACK_RECEIVED

FORMATMESSAGE

@@ROWCOUNT

GET_FILESTREAM_TRANSACTION_CONTEXT

@@TRANCOUNT

GETANSINULL

BINARY_CHECKSUM

HOST_ID

CHECKSUM

HOST_NAME

COMPRESS

ISNULL

CONNECTIONPROPERTY

ISNUMERIC

CONTEXT_INFO

MIN_ACTIVE_ROWVERSION

CURRENT_REQUEST_ID

NEWID

CURRENT_TRANSACTION_ID

NEWSEQUENTIALID

DECOMPRESS

ROWCOUNT_BIG

ERROR_LINE

SESSION_CONTEXT

ERROR_MESSAGE

SESSION_ID

ERROR_NUMBER

XACT_STATE

Built-in Functions (Transact-SQL)