System Functions (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2012) ![no](media/no.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)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](../../t-sql/functions/error-transact-sql.md) ERROR_SEVERITY
[@@IDENTITY](../../t-sql/functions/identity-transact-sql.md) ERROR_STATE
[@@PACK_RECEIVED](../../t-sql/functions/pack-received-transact-sql.md) FORMATMESSAGE
[@@ROWCOUNT](../../t-sql/functions/rowcount-transact-sql.md) GET_FILESTREAM_TRANSACTION_CONTEXT
[@@TRANCOUNT](../../t-sql/functions/trancount-transact-sql.md) 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)