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 |