System Functions (Transact-SQL)

APPLIES TO: yes SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

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

See Also