public static class DBMSHandlerMSSQL.DBCommandMSSQL extends DBCommand
DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected int |
limit |
protected int |
skipRows |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, parentTables, select, selectDistinct, set, where
cmdQuery, orderBy, SF_DEFAULT, SF_SKIP_FROM, SF_SKIP_GROUP, SF_SKIP_LIMIT, SF_SKIP_ORDER, SF_SKIP_SELECT, SF_SKIP_WHERE
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE
Constructor and Description |
---|
DBCommandMSSQL(DBMSHandlerMSSQL dbms,
boolean autoPrepareStmt) |
Modifier and Type | Method and Description |
---|---|
protected void |
addSelect(DBSQLBuilder sql) |
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
void |
getSelect(DBSQLBuilder sql,
int flags)
Creates a select SQL-Statement
|
DBCommand |
limitRows(int numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
DBCommand |
skipRows(int skipRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addUpdateForTable, addUpdateWithJoins, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, createSQLBuilder, findConstraintOn, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParams, getParamValues, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, join, joinLeft, joinLeft, joinRight, joinRight, orderBy, orderBy, orderBy, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, set, set, setConstraint, setParentTables, useCmdParam, where, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, getSelect, hasOrderBy, intersect, not, notEmpty, result, union, unionAll
checkParamNull
public DBCommandMSSQL(DBMSHandlerMSSQL dbms, boolean autoPrepareStmt)
public DBCommand limitRows(int numRows)
DBCommand
public DBCommand skipRows(int skipRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(DBSQLBuilder sql, int flags)
DBCommand
protected void addSelect(DBSQLBuilder sql)
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.