public static class DBMSHandlerMSSQL.DBCommandMSSQL extends DBCommand
DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected int |
limit |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, select, selectDistinct, set, where
cmdQuery, orderBy
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE
Constructor and Description |
---|
DBCommandMSSQL(boolean autoPrepareStmt) |
Modifier and Type | Method and Description |
---|---|
protected void |
addSelect(StringBuilder buf) |
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
DBCommand |
limitRows(int numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoin, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addUpdateForTable, addUpdateWithJoins, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParamValues, getRowSetList, getSelect, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, joinLeft, joinRight, mergeSubqueryParams, notifyParamUsage, 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, skipRows, useCmdParam, where, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, hasOrderBy, intersect, result, union, unionAll
getObjectValue
checkParamNull
public DBCommand limitRows(int numRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
protected void addSelect(StringBuilder buf)
Copyright © 2008–2022 Apache Software Foundation. All rights reserved.