Finding Session Id in MS SQL User's Current Process

In MS SQL, the following query is run to find the Session Id of the logged in user in the current process.

SELECT @@SPID AS 'SessionId'


You May Interest

How to Optimize Stored Procedure in SQL Server ?

What is Blocking in SQL Server ?

What is The Concept of Piecemeal Restore on SQL Server ?

What is a ROLLUP Clause in SQL Server ?

What is Service Broker in SQL Server ?