MssqlOutputTarget class
Where an OUTPUT … INTO clause puts its rows.
INTO is not an optimisation. A table carrying an enabled trigger makes
SQL Server reject a bare OUTPUT outright (error 334), so capturing the
written keys into a table variable and reading the stored rows back from
it is the only readback such a table has.
- Annotations
-
- @immutable
Constructors
-
MssqlOutputTarget.table(MssqlSource source, {Iterable<
String> columns = const <String>[]}) - A real table or table-valued variable named like one.
-
MssqlOutputTarget.variable(String name, {Iterable<
String> columns = const <String>[]}) -
A
DECLARE @name TABLE (…)variable in the same batch.
Properties
-
columns
→ List<
String> -
The target's column list, in the order the output columns fill it.
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- quoted → String
-
The target as it is written, already quoted or already prefixed with
@.final - runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- sql → String
-
no setter
Methods
-
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