MssqlCte class

One named query in a WITH clause.

A common table expression is how SQL Server writes a query that refers to itself, which is the only way to walk a hierarchy — a category tree, an organisation chart, a bill of materials — in one statement.

Annotations

• @immutable

Constructors

MssqlCte(String name, MssqlSelectQuery query, {List<String> columns = const <String>[]})

MssqlCte.recursive(String name, {required MssqlSelectQuery anchor, required MssqlSelectQuery recursive, required List<String> columns})

A recursive expression: the anchor member, then the member that refers back to name.

factory

Properties

columns → List<String>

The names the expression exposes, which override whatever the query projects. Required for MssqlCte.recursive and optional otherwise.

final

hashCode → int

The hash code for this object.

no setter, inherited

name → String

final

query → MssqlSelectQuery

final

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

compile(MssqlParameterAllocator parameters, MssqlDialect dialect) → String

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

toString() → String

A string representation of this object.

inherited

Operators

operator ==(Object other) → bool

The equality operator.

inherited