Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English
Read in English Edit
Twitter LinkedIn Facebook Email

System Functions (Transact-SQL)

  • Article
  • 05/23/2023

In this article

Applies to: SQL Server Azure SQL Managed Instance SQL 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

See Also

Built-in Functions (Transact-SQL)


Additional resources

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023

Additional resources

In this article

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023