SQL Server Transact Basic to Expert - Get Current SQL Server Connections Session ID

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.