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 is Deadlock Different From a Blocking Situation in SQL Server ...

What are the Limitations of Indexed Views in SQL Server ?

What is an OUTPUT Clause Inside SQL Server ?

What are Replication and Database Mirroring in SQL Server ?

Making a Backup of MS SQL Database With Query