Returns the ID of the current request within the current session.
Transact-SQL Syntax Conventions
CURRENT_REQUEST_ID()
smallint
To find exact information about the current session and current request, use @@SPID and CURRENT_REQUEST_ID(), respectively.