Systemfunktionen (Transact-SQL)System Functions (Transact-SQL)

DIESES THEMA GILT FÜR: jaSQL Server (ab 2012)neinAzure SQL-DatenbankneinAzure SQL Data Warehouse neinParallel Data Warehouse THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Die folgenden Systemfunktionen führen Vorgänge mit Werten, Objekten und Einstellungen in SQL ServerSQL Server aus und geben Informationen über diese zurück.The following system functions perform operations on and return information about values, objects, and settings in SQL ServerSQL Server.

$PARTITION$PARTITION ERROR_PROCEDUREERROR_PROCEDURE
@@ERROR@@ERROR ERROR_SEVERITYERROR_SEVERITY
@@IDENTITY@@IDENTITY ERROR_STATEERROR_STATE
@@PACK_RECEIVED@@PACK_RECEIVED FORMATMESSAGEFORMATMESSAGE
@@ROWCOUNT@@ROWCOUNT GET_FILESTREAM_TRANSACTION_CONTEXTGET_FILESTREAM_TRANSACTION_CONTEXT
@@TRANCOUNT@@TRANCOUNT GETANSINULLGETANSINULL
BINARY_CHECKSUMBINARY_CHECKSUM HOST_IDHOST_ID
CHECKSUMCHECKSUM HOST_NAMEHOST_NAME
COMPRESSCOMPRESS ISNULLISNULL
CONNECTIONPROPERTYCONNECTIONPROPERTY ISNUMERICISNUMERIC
CONTEXT_INFOCONTEXT_INFO MIN_ACTIVE_ROWVERSIONMIN_ACTIVE_ROWVERSION
CURRENT_REQUEST_IDCURRENT_REQUEST_ID NEWIDNEWID
CURRENT_TRANSACTION_IDCURRENT_TRANSACTION_ID NEWSEQUENTIALIDNEWSEQUENTIALID
DECOMPRESSDECOMPRESS ROWCOUNT_BIGROWCOUNT_BIG
ERROR_LINEERROR_LINE SESSION_CONTEXTSESSION_CONTEXT
ERROR_MESSAGEERROR_MESSAGE SESSION_IDSESSION_ID
ERROR_NUMBERERROR_NUMBER XACT_STATEXACT_STATE

Siehe auchSee Also

Integrierte Funktionen (Transact-SQL)Built-in Functions (Transact-SQL)