Class Atk4\Data\Persistence\Sql\Mssql\Query

`extends`	`Query`
`uses`	`ExpressionTrait`

Atk4\Data\Persistence\Sql\Expression implements Expressionable, ArrayAccess<int|string, mixed> uses DiContainerTrait
- Atk4\Data\Persistence\Sql\Query
  - Atk4\Data\Persistence\Sql\Mssql\Query uses ExpressionTrait

Located at data/src/Persistence/Sql/Mssql/Query.php

Methods
`protected`	`deduplicateRenderOrder(array $sqls): array` Overrides `Atk4\Data\Persistence\Sql\Query::deduplicateRenderOrder()`	#
`protected`	`_renderLimit(): ?string` Overrides `Atk4\Data\Persistence\Sql\Query::_renderLimit()`	#
`public`	`groupConcat($field, string $separator = ',')` Returns a query for a function, which can be used as part of the GROUP query which would concatenate all matching… Returns a query for a function, which can be used as part of the GROUP query which would concatenate all matching fields. Overrides `Atk4\Data\Persistence\Sql\Query::groupConcat()`	#
`public`	`exists()` Creates 'select exists' query based on the query object. Creates 'select exists' query based on the query object. Overrides `Atk4\Data\Persistence\Sql\Query::exists()`	#

Methods inherited from Atk4\Data\Persistence\Sql\Query
field(), _renderField(), _renderFieldNoalias(), table(), getMainTable(), _renderTable(), _renderTableNoalias(), _renderFrom(), with(), _renderWith(), join(), _renderJoin(), where(), having(), _subrenderWhere(), _renderConditionBinary(), _renderConditionInOperator(), _subrenderCondition(), _renderWhere(), _renderOrwhere(), _renderAndwhere(), _renderHaving(), group(), _renderGroup(), set(), setMulti(), _renderSet(), _renderSetFields(), _renderSetValues(), option(), _renderOption(), order(), _renderOrder(), limit(), __debugInfo(), render(), renderNested(), mode(), expr(), dsql(), exprNow(), orExpr(), andExpr(), caseExpr(), caseWhen(), caseElse(), _renderCase(), _setArgs()

Methods inherited from Atk4\Data\Persistence\Sql\Query

field(), _renderField(), _renderFieldNoalias(), table(), getMainTable(), _renderTable(), _renderTableNoalias(), _renderFrom(), with(), _renderWith(), join(), _renderJoin(), where(), having(), _subrenderWhere(), _renderConditionBinary(), _renderConditionInOperator(), _subrenderCondition(), _renderWhere(), _renderOrwhere(), _renderAndwhere(), _renderHaving(), group(), _renderGroup(), set(), setMulti(), _renderSet(), _renderSetFields(), _renderSetValues(), option(), _renderOption(), order(), _renderOrder(), limit(), __debugInfo(), render(), renderNested(), mode(), expr(), dsql(), exprNow(), orExpr(), andExpr(), caseExpr(), caseWhen(), caseElse(), _renderCase(), _setArgs()

Methods inherited from Atk4\Data\Persistence\Sql\Expression
`__construct(), getDsqlExpression(), offsetExists(), offsetGet(), offsetSet(), offsetUnset(), reset(), consume(), escapeParam(), escapeStringLiteral(), escapeIdentifier(), escapeIdentifierSoft(), isUnescapableIdentifier(), getDebugQuery(), hasNativeNamedParamSupport(), updateRenderBeforeExecute(), _executeStatement(), _execute(), executeQuery(), executeStatement(), castFloatToString(), getRowsIterator(), getRows(), getRow(), getOne()`

Methods inherited from Atk4\Data\Persistence\Sql\Expression

__construct(), getDsqlExpression(), offsetExists(), offsetGet(), offsetSet(), offsetUnset(), reset(), consume(), escapeParam(), escapeStringLiteral(), escapeIdentifier(), escapeIdentifierSoft(), isUnescapableIdentifier(), getDebugQuery(), hasNativeNamedParamSupport(), updateRenderBeforeExecute(), _executeStatement(), _execute(), executeQuery(), executeStatement(), castFloatToString(), getRowsIterator(), getRows(), getRow(), getOne()

Methods used from Atk4\Core\DiContainerTrait
`setDefaults(), setMissingProperty(), assertInstanceOf(), _fromSeedPrecheck(), fromSeed(), fromSeedUnsafe()`

Methods used from Atk4\Data\Persistence\Sql\Mssql\ExpressionTrait
`render(), hasNativeNamedParamSupport(), updateRenderBeforeExecute(), _execute()`

Constants inherited from Atk4\Data\Persistence\Sql\Expression
`ESCAPE_PARAM, ESCAPE_IDENTIFIER, ESCAPE_IDENTIFIER_SOFT, ESCAPE_NONE, QUOTED_TOKEN_REGEX`

Properties
`protected`	`string`	`$identifierEscapeChar = ']'`	#
`protected`	`string`	`$expressionClass = Expression::class`	#
`protected`	`string`	`$templateInsert = "begin try\n insert[option] into [tableNoalias] ([setFields]) values ([setValues]);\nend try begin catch\n if ERROR_NUMBER() = 544 begin\n set IDENTITY_INSERT [tableNoalias] on;\n begin try\n insert[option] into [tableNoalias] ([setFields]) values ([setValues]);\n set IDENTITY_INSERT [tableNoalias] off;\n end try begin catch\n set IDENTITY_INSERT [tableNoalias] off;\n throw;\n end catch\n end else begin\n throw;\n end\nend catch"`	#

Properties inherited from Atk4\Data\Persistence\Sql\Query
`$mode, $defaultField, $wrapInParentheses, $supportedOperators, $templateSelect, $templateReplace, $templateDelete, $templateUpdate, $templateTruncate`

Properties inherited from Atk4\Data\Persistence\Sql\Expression
`$template, $args, $paramBase, $renderParamBase, $renderParams, $connection,`

Namespaces

Classes

Traits

Class Atk4\Data\Persistence\Sql\Mssql\Query

Overrides

Overrides

Overrides

Overrides