| title | SESSION_CONTEXT (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/22/2016 | ||||
| ms.prod | sql-non-specified | ||||
| ms.prod_service | database-engine, sql-database | ||||
| ms.service | |||||
| ms.component | t-sql|functions | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | b6bdbc54-331a-43cc-ab3d-3872d6a12100 | ||||
| caps.latest.revision | 11 | ||||
| author | edmacauley | ||||
| ms.author | edmaca | ||||
| manager | craigg | ||||
| ms.workload | On Demand |
[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]
Returns the value of the specified key in the current session context. The value is set by using the sp_set_session_context (Transact-SQL) procedure.
Transact-SQL Syntax Conventions
SESSION_CONTEXT(N'key')
'key'
The key (type sysname) of the value being retrieved.
sql_variant
The value associated with the specified key in the session context, or NULL if no value has been set for that key.
Any user can read the session context for their session.
SESSION_CONTEXT’s MARS behavior is similar to that of CONTEXT_INFO. If a MARS batch sets a key-value pair, the new value will not be returned in other MARS batches on the same connection unless they started after the batch that set the new value completed. If multiple MARS batches are active on a connection, values cannot be set as “read_only.” This prevents race conditions and non-determinism about which value “wins.”
The following simple example sets the session context value for key user_id to 4, and then uses the SESSION_CONTEXT function to retrieve the value.
EXEC sp_set_session_context 'user_id', 4;
SELECT SESSION_CONTEXT(N'user_id');
sp_set_session_context (Transact-SQL)
CURRENT_TRANSACTION_ID (Transact-SQL)
Row-Level Security
CONTEXT_INFO (Transact-SQL)
SET CONTEXT_INFO (Transact-SQL)