CURRENT_TRANSACTION_ID (Transact-SQL)
Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance
This function returns the transaction ID of the current transaction in the current session.
Transact-SQL syntax conventions
Syntax
CURRENT_TRANSACTION_ID( )
Return types
bigint
Return Value
The transaction ID of the current transaction in the current session, taken from sys.dm_tran_current_transaction (Transact-SQL).
Permissions
Any user can return the transaction ID of the current session.
Examples
This example returns the transaction ID of the current session:
SELECT CURRENT_TRANSACTION_ID();
See also
sp_set_session_context (Transact-SQL)
SESSION_CONTEXT (Transact-SQL)
Row-Level Security
CONTEXT_INFO (Transact-SQL)
SET CONTEXT_INFO (Transact-SQL)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Uskoro: tokom 2024. postepeno ćemo ukidati probleme s uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zamijeniti ga novim sistemom povratnih informacija. Za više informacija, pogledajtePošalјite i prikažite povratne informacije za