Table of Contents

Class QueryStoreSchema.QueryContextSetting

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.query_context_settings (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

Contains information about the semantics affecting context settings associated with a query. There are a number of context settings available in SQL Server that influence the query semantics (defining the correct result of the query). The same query text compiled under different settings may produce different results (depending on the underlying data).


See sys.query_context_settings.

[Table(Schema = "sys", Name = "query_context_settings", IsView = true)]
public class QueryStoreSchema.QueryContextSetting
Inheritance
QueryStoreSchema.QueryContextSetting
Extension Methods

Properties

AcceptableCursorOptions

Cursor options that SQL Server may implicitly convert to in order to support the execution of the statement.

[Column("acceptable_cursor_options")]
[NotNull]
public int AcceptableCursorOptions { get; set; }

Property Value

int

ContextSettingsID

Primary key. This value is exposed in Showplan XML for queries.

[Column("context_settings_id")]
[NotNull]
public long ContextSettingsID { get; set; }

Property Value

long

DateFirst

The date first value. For more information, see SET DATEFIRST (Transact-SQL).

[Column("date_first")]
[NotNull]
public byte DateFirst { get; set; }

Property Value

byte

DateFormat

The date format. For more information, see SET DATEFORMAT (Transact-SQL).

[Column("date_format")]
[NotNull]
public short DateFormat { get; set; }

Property Value

short

DefaultSchemaID

ID of the default schema, which is used to resolve names that are not fully qualified.

[Column("default_schema_id")]
[NotNull]
public int DefaultSchemaID { get; set; }

Property Value

int

IsContained

1 indicates a contained database.

[Column("is_contained")]
[Nullable]
public byte[]? IsContained { get; set; }

Property Value

byte[]

IsReplicationSpecific

Used for replication.

[Column("is_replication_specific")]
[NotNull]
public bool IsReplicationSpecific { get; set; }

Property Value

bool

LanguageID

The id of the language. For more information, see sys.syslanguages (Transact-SQL).

[Column("language_id")]
[NotNull]
public short LanguageID { get; set; }

Property Value

short

MergeActionType

The type of trigger execution plan used as the result of a MERGE statement.

0 indicates a non-trigger plan, a trigger plan that does not execute as the result of a MERGE statement, or a trigger plan that executes as the result of a MERGE statement that only specifies a DELETE action.

1 indicates an INSERT trigger plan that runs as the result of a MERGE statement.

2 indicates an UPDATE trigger plan that runs as the result of a MERGE statement.

3 indicates a DELETE trigger plan that runs as the result of a MERGE statement containing a corresponding INSERT or UPDATE action.



For nested triggers run by cascading actions, this value is the action of the MERGE statement that caused the cascade.

[Column("merge_action_type")]
[NotNull]
public short MergeActionType { get; set; }

Property Value

short

RequiredCursorOptions

Cursor options specified by the user such as the cursor type.

[Column("required_cursor_options")]
[NotNull]
public int RequiredCursorOptions { get; set; }

Property Value

int

SetOptions

Bit mask reflecting state of several SET options. For more information, see sys.dm_exec_plan_attributes (Transact-SQL).

[Column("set_options")]
[Nullable]
public byte[]? SetOptions { get; set; }

Property Value

byte[]

Status

Bitmask field that indicates type of query or context in which query was executed.
Column value can be combination of multiple flags (expressed in hexadecimal):

0x0 - regular query (no specific flags)

0x1 - query that was executed through one of the cursor APIs stored procedures

0x2 - query for notification

0x4 - internal query

0x8 - auto parameterized query without universal parameterization

0x10 - cursor fetch refresh query

0x20 - query that is being used in cursor update requests

0x40 - initial result set is returned when a cursor is opened (Cursor Auto Fetch)

0x80 - encrypted query

0x100 - query in context of row-level security predicate

[Column("status")]
[Nullable]
public byte[]? Status { get; set; }

Property Value

byte[]