Finding Session Id in MS SQL User's Current Process

54 Reads Ms Sql

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'
Ms Sql

You May Interest

What is the Bookmark Lookup and RID Lookup in SQL Server ?

Differences Between Stored Procedure and Function in MS SQL

What is the Merge Statement in SQL Server ?

What is a View in SQL Server ?

What is the Filtered Index in SQL Server ?