CONTEXT_INFO
SET CONTEXT_INFO 0x55555;
DECLARE @BinVar varbinary(128), @ci VARBINARY(128);
SET @BinVar = CAST('MyContextInfoInHere' AS VARBINARY(128));
SET @ci = CONTEXT_INFO()
SET CONTEXT_INFO @BinVar;
IF CONTEXT_INFO() = CAST('MyContextInfoInHere' AS VARBINARY(128))
BEGIN
SELECT CONTEXT_INFO() AS [CONTEXT_INFO]
END
SET CONTEXT_INFO @ci
SELECT CONTEXT_INFO() AS [CONTEXT_INFO]
SESSION_CONTEXT
EXEC sp_set_session_context @key = N'BypassTrigger', @value = 1;
/* T-SQL */
EXEC sp_set_session_context @key = N'BypassTrigger', @value = 0;
IF CAST(SESSION_CONTEXT(N'BypassTrigger') AS BIT) = 1
BEGIN
RETURN;
END