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 |