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