This blog shows how to get the current Connections session ID in SQL Server

Example:

SELECT @@SPID SPID

The expected result would vary based on the execution.