Funciones del sistema (Transact-SQL)System Functions (Transact-SQL)

SE APLICA A: síSQL Server (a partir de 2012) noAzure SQL Database noAzure SQL Data Warehouse noAlmacenamiento de datos paralelos APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Las siguientes funciones del sistema realizan operaciones y devuelven información sobre valores, objetos y configuraciones de SQL ServerSQL Server.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

Ver tambiénSee Also

Funciones integradas (Transact-SQL)Built-in Functions (Transact-SQL)