public static class ERXSQLHelper.MicrosoftSQLHelper extends ERXSQLHelper
ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DB2SQLHelper, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FirebirdSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelperlog| Constructor and Description |
|---|
MicrosoftSQLHelper() |
| Modifier and Type | Method and Description |
|---|---|
protected java.util.regex.Pattern |
commentPattern()
Returns a pattern than matches lines that start with "--".
|
java.lang.String |
externalTypeForJDBCType(JDBCAdaptor adaptor,
int type)
JDBCAdaptor.externalTypeForJDBCType just returns the first type it finds
instead of trying to find a best match.
|
java.lang.String |
limitExpressionForSQL(EOSQLExpression expression,
EOFetchSpecification fetchSpecification,
java.lang.String sql,
long start,
long end) |
java.lang.String |
sqlForCreateIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating an index on the given set
of columns
|
java.lang.String |
sqlForCreateUniqueIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
Returns the SQL expression for creating a unique index on the given set
of columns
|
_groupByOrHavingIndex, _orderByIndex, addGroupByClauseToExpression, addGroupByClauseToExpression, addHavingCountClauseToExpression, appendItemToListString, attributesToFetchForEntity, canReliablyPerformDistinctWithSortOrderings, columnIndexesFromColumnNames, columnNamesFromColumnIndexes, commandSeparatorChar, commandSeparatorString, createDependentSchemaSQLForEntities, createIndexSQLForEntities, createIndexSQLForEntities, createSchemaSQLForEntitiesInDatabaseContext, createSchemaSQLForEntitiesInModel, createSchemaSQLForEntitiesInModelAndOptions, createSchemaSQLForEntitiesInModelWithName, createSchemaSQLForEntitiesInModelWithNameAndOptions, createSchemaSQLForEntitiesWithOptions, createSchemaSQLForEntitiesWithOptions, customQueryExpressionHintAsString, defaultOptionDictionary, formatValueForAttribute, getNextValFromSequenceNamed, handleDatabaseException, jdbcTypeForCustomType, maximumElementPerInClause, migrationTableName, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, prepareConnectionForSchemaChange, quoteColumnName, readFormatForAggregateFunction, readFormatForAggregateFunction, reassignExternalTypeForValueTypeOverride, removeSelectFromExpression, restoreConnectionSettingsAfterSchemaChange, rowCountForFetchSpecification, shouldExecute, shouldPerformDistinctInMemory, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCountDistinct, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForFullTextQuery, sqlForGetNextValFromSequencedNamed, sqlForRegularExpressionQuery, sqlForSubquery, sqlWhereClauseStringForKey, varcharLargeColumnWidth, varcharLargeJDBCTypeprotected java.util.regex.Pattern commentPattern()
commentPattern in class ERXSQLHelperpublic java.lang.String externalTypeForJDBCType(JDBCAdaptor adaptor, int type)
ERXSQLHelperexternalTypeForJDBCType in class ERXSQLHelperadaptor - the adaptor to retrieve an external type fortype - the JDBC type numberpublic java.lang.String limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, java.lang.String sql, long start, long end)
limitExpressionForSQL in class ERXSQLHelperpublic java.lang.String sqlForCreateUniqueIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateUniqueIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onpublic java.lang.String sqlForCreateIndex(java.lang.String indexName,
java.lang.String tableName,
ERXSQLHelper.ColumnIndex... columnIndexes)
ERXSQLHelpersqlForCreateIndex in class ERXSQLHelperindexName - the name of the index to createtableName - the name of the containing tablecolumnIndexes - the list of columns to index onCopyright © 2002 – 2022 Project Wonder.