Returns the current session ID as an integer.

Syntax

---

CURRENT_SESSIONID()

Returns

---

INTEGER

Usage

---

The CURRENT_SESSIONID function returns the current session ID as an integer.

Examples

---

SELECT *
FROM Configuration.ServerSessionLocks
WHERE SessionID = CURRENT_SESSIONID()

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: