CURRENT_REQUEST_ID (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
This function returns the ID of the current request within the current session.
Transact-SQL syntax conventions
Syntax
CURRENT_REQUEST_ID()
Return types
smallint
Remarks
To find exact information about the current session, use @@SPID. For exact information about the current request, use CURRENT_REQUEST_ID().