System Functions (Transact-SQL)

The following 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	GETANSINULL
@@TRANCOUNT	GET_FILESTREAM_TRANSACTION_CONTEXT
BINARY_CHECKSUM	HOST_ID
CAST and CONVERT	HOST_NAME
CHECKSUM	ISNULL
CONNECTIONPROPERTY	ISNUMERIC
CONTEXT_INFO	MIN_ACTIVE_ROWVERSION
CURRENT_REQUEST_ID	NEWID
ERROR_LINE	NEWSEQUENTIALID
ERROR_MESSAGE	PathName
ERROR_NUMBER	XACT_STATE

See Also

Reference

Built-in Functions (Transact-SQL)