how to get current user process session id in sql server

SQL Server @@SPID

SQL Server @@SPID is a SQL Server configuration function that is used to return the session id of current user process.

SYNTAX
@@SPID