public class MSSQL2008DatabaseAdapter extends MSSQLDatabaseAdapter
Constructor and Description |
---|
MSSQL2008DatabaseAdapter() |
Modifier and Type | Method and Description |
---|---|
String |
getDescription() |
String |
getName() |
String |
getSelectStatement(String tableName,
String columnNames,
String whereClause,
String orderByClause,
Long limit,
Long offset)
Returns a SQL SELECT statement with the given clauses applied.
|
String |
getSelectStatement(String tableName,
String columnNames,
String whereClause,
String orderByClause,
Long limit,
Long offset,
String columnForPartitioning)
Returns a SQL SELECT statement with the given clauses applied.
|
unwrapIdentifier
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getTableAliasClause, getUpsertStatement, supportsUpsert
public String getName()
getName
in interface DatabaseAdapter
getName
in class MSSQLDatabaseAdapter
public String getDescription()
getDescription
in interface DatabaseAdapter
getDescription
in class MSSQLDatabaseAdapter
public String getSelectStatement(String tableName, String columnNames, String whereClause, String orderByClause, Long limit, Long offset)
DatabaseAdapter
getSelectStatement
in interface DatabaseAdapter
getSelectStatement
in class MSSQLDatabaseAdapter
tableName
- The name of the table to fetch rows fromcolumnNames
- The names of the columns to fetch from the tablewhereClause
- The filter to apply to the statement. This should not include the WHERE keywordorderByClause
- The columns/clause used for ordering the result rows. This should not include the ORDER BY keywordslimit
- The value for the LIMIT clause (i.e. the number of rows to return)offset
- The value for the OFFSET clause (i.e. the number of rows to skip)public String getSelectStatement(String tableName, String columnNames, String whereClause, String orderByClause, Long limit, Long offset, String columnForPartitioning)
DatabaseAdapter
getSelectStatement
in interface DatabaseAdapter
getSelectStatement
in class MSSQLDatabaseAdapter
tableName
- The name of the table to fetch rows fromcolumnNames
- The names of the columns to fetch from the tablewhereClause
- The filter to apply to the statement. This should not include the WHERE keywordorderByClause
- The columns/clause used for ordering the result rows. This should not include the ORDER BY keywordslimit
- The value for the LIMIT clause (i.e. the number of rows to return)offset
- The value for the OFFSET clause (i.e. the number of rows to skip)columnForPartitioning
- The (optional) column name that, if provided, the limit and offset values are based on values from the column itself (rather than the row number)Copyright © 2020 Apache NiFi Project. All rights reserved.