What is the use of @@SPID?

MindStick Software Pvt Ltd · 2019-09-19T02:41:00.857Z

@@SPID The @@SPID returns the session ID of the current user process. The SQL @@SPID is one of the Configuration Function, which will return the session ID that is currently being used. Syntax behind this is - Example

MindStick Software Pvt Ltd 1080 19 Sep 2019

1 Answers

MindStick Software Pvt Ltd 19 Sep 2019

@@SPID

The @@SPID returns the session ID of the current user process.
The SQL @@SPID is one of the Configuration Function, which will return the session ID that is currently being used. Syntax behind this is -

@@SPID

Example

SELECT @@SPID AS 'SP ID', 

       SYSTEM_USER AS 'Login Name', 

       USER AS 'User Name';

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

interview

What is the use of @@SPID?

Can you answer this question?

1 Answers