System Functions (Transact-SQL)

  • 2 minutes to read
  • Contributors
    • mashathomas
    • Craig Guyer
    • Ed Macauley
THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel 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

Built-in Functions (Transact-SQL)