System Functions (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

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

Related content

• What are the SQL database functions?