System Functions (Transact-SQL)

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

$PARTITION

ERROR_SEVERITY

@@ERROR

ERROR_STATE

@@IDENTITY

FORMATMESSAGE

@@PACK_RECEIVED

GETANSINULL

@@ROWCOUNT

GET_FILESTREAM_TRANSACTION_CONTEXT

@@TRANCOUNT

HOST_ID

BINARY_CHECKSUM

HOST_NAME

CHECKSUM

ISNULL

CONNECTIONPROPERTY

ISNUMERIC

CONTEXT_INFO

MIN_ACTIVE_ROWVERSION

CURRENT_REQUEST_ID

NEWID

ERROR_LINE

NEWSEQUENTIALID

ERROR_MESSAGE

ROWCOUNT_BIG

ERROR_NUMBER

XACT_STATE

ERROR_PROCEDURE

See Also

Reference

Built-in Functions (Transact-SQL)