SQLServer2012Dialect

java.lang.Object
- org.hibernate.dialect.Dialect
- - org.hibernate.dialect.SQLServerDialect
  - - org.hibernate.dialect.CTPSQLServerDialect
    - - org.hibernate.dialect.SQLServer2005Dialect
      - org.hibernate.dialect.SQLServer2008Dialect
        
        org.hibernate.dialect.SQLServer2012Dialect

所有已实现的接口:

CTPDBDialect
```
public class SQLServer2012Dialect
extends SQLServer2008Dialect
```
SQLServer2012 方言实现
使用 OFFSET FETCH 分页算法

该算百万分页性能可以每页保持几百ms，适用于sqlserver2012+

从以下版本开始:

sqlserver2012+

字段概要
- 从类继承的字段 org.hibernate.dialect.SQLServer2005Dialect
  DISTINCT, FROM, LOGGER, ORDER_BY, ORDER_BY_PATTERN, SELECT
- 从类继承的字段 org.hibernate.dialect.Dialect
  CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

构造器概要

构造器
构造器和说明

SQLServer2012Dialect()

构造器
构造器和说明
`SQLServer2012Dialect()`

方法概要

所有方法实例方法具体方法
限定符和类型	方法和说明
`java.lang.String`	`applyLocksToSql(java.lang.String arg0, java.util.Map arg1, java.util.Map arg2)`
`int`	`convertToFirstRowValue(int zeroBasedFirstResult)`
`boolean`	`dropTemporaryTableAfterUse()`
`java.lang.String`	`generateTemporaryTableName(java.lang.String arg0)`
`java.lang.String`	`getAddColumnString()`
`java.lang.String`	`getCreateSequenceString(java.lang.String sequenceName)`
`java.lang.String`	`getDropSequenceString(java.lang.String sequenceName)`
`java.lang.String`	`getForUpdateString()`
`java.lang.String`	`getIdentityColumnString()`
`java.lang.String`	`getIdentitySelectString()`
`java.lang.String`	`getLimitString(java.lang.String querySelect, int offset, int limit)` SQLServer 强制使用 OFFSET/LIMIT 遵循以下规则 1.
`java.lang.String`	`getNullColumnString()`
`java.lang.String`	`getQuerySequencesString()`
`java.sql.ResultSet`	`getResultSet(java.sql.CallableStatement arg0)`
`java.lang.String`	`getSelectSequenceNextValString(java.lang.String sequenceName)`
`java.lang.String`	`getSequenceNextValString(java.lang.String sequenceName)`
`boolean`	`isCurrentTimestampSelectStringCallable()`
`boolean`	`qualifyIndexName()`
`int`	`registerResultSetOutParameter(java.sql.CallableStatement arg0, int arg1)`
`boolean`	`supportsCurrentTimestampSelection()`
`boolean`	`supportsEmptyInList()`
`boolean`	`supportsExistsInSelect()`
`boolean`	`supportsIdentityColumns()`
`boolean`	`supportsInsertSelectIdentity()`
`boolean`	`supportsLimit()`
`boolean`	`supportsLimitOffset()`
`boolean`	`supportsPooledSequences()`
`boolean`	`supportsSequences()`
`boolean`	`supportsTemporaryTables()`
`boolean`	`supportsVariableLimit()`
`boolean`	`useMaxForLimit()`

从类继承的方法 org.hibernate.dialect.SQLServer2005Dialect
bindLimitParametersFirst, doWithRowNumber, findIndexOfPattern, getLimitString, getSelectColumnsWithoutAliases, relaceAllColumnsAliases, replaceDistinctWithGroupBy

从类继承的方法 org.hibernate.dialect.CTPSQLServerDialect
getModifyColumnString, getTextLimit

从类继承的方法 org.hibernate.dialect.SQLServerDialect
appendIdentitySelectToInsert, appendLockHint, areStringComparisonsCaseInsensitive, closeQuote, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, getCurrentTimestampSelectString, getNoColumnsInsertString, getSelectGUIDString, openQuote, supportsCircularCascadeDeleteConstraints, supportsLobValueChangePropogation, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor

从类继承的方法 org.hibernate.dialect.Dialect
bindLimitParametersInReverseOrder, buildSQLExceptionConverter, createCaseFragment, createOuterJoinFragment, dropConstraints, forceLimitUsage, forUpdateOfColumns, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSQLFunctionName, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getKeywords, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNativeIdentifierGeneratorClass, getSelectClauseNullString, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, performTemporaryTableDDLInIsolation, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCascadeDelete, supportsColumnCheck, supportsCommentOn, supportsExpectedLobUsagePattern, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob

从类继承的方法 java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- 构造器详细资料
  - SQLServer2012Dialect
```
public SQLServer2012Dialect()
```
- 方法详细资料
  - getLimitString
```
public java.lang.String getLimitString(java.lang.String querySelect,
                                       int offset,
                                       int limit)
```
    SQLServer 强制使用 OFFSET/LIMIT 遵循以下规则 1. 必须要有'ORDER BY' 子句 2. 必须要有'OFFSET ...'子句 3. 不允计出现TOP 子句
    
    覆盖:
    
    getLimitString 在类中 SQLServer2005Dialect
    
    参数:
    
    querySelect -
    
    offset -
    
    limit -
    
    返回:
  - useMaxForLimit
```
public boolean useMaxForLimit()
```
    覆盖:
    
    useMaxForLimit 在类中 SQLServer2005Dialect
  - convertToFirstRowValue
```
public int convertToFirstRowValue(int zeroBasedFirstResult)
```
    覆盖:
    
    convertToFirstRowValue 在类中 SQLServer2005Dialect
  - supportsLimitOffset
```
public boolean supportsLimitOffset()
```
    覆盖:
    
    supportsLimitOffset 在类中 SQLServer2005Dialect
  - supportsLimit
```
public boolean supportsLimit()
```
    覆盖:
    
    supportsLimit 在类中 SQLServer2005Dialect
  - supportsVariableLimit
```
public boolean supportsVariableLimit()
```
    覆盖:
    
    supportsVariableLimit 在类中 SQLServer2005Dialect
  - supportsSequences
```
public boolean supportsSequences()
```
    覆盖:
    
    supportsSequences 在类中 org.hibernate.dialect.Dialect
  - supportsPooledSequences
```
public boolean supportsPooledSequences()
```
    覆盖:
    
    supportsPooledSequences 在类中 org.hibernate.dialect.Dialect
  - getCreateSequenceString
```
public java.lang.String getCreateSequenceString(java.lang.String sequenceName)
```
    覆盖:
    
    getCreateSequenceString 在类中 org.hibernate.dialect.Dialect
  - getDropSequenceString
```
public java.lang.String getDropSequenceString(java.lang.String sequenceName)
```
    覆盖:
    
    getDropSequenceString 在类中 org.hibernate.dialect.Dialect
  - getSelectSequenceNextValString
```
public java.lang.String getSelectSequenceNextValString(java.lang.String sequenceName)
```
    覆盖:
    
    getSelectSequenceNextValString 在类中 org.hibernate.dialect.Dialect
  - getSequenceNextValString
```
public java.lang.String getSequenceNextValString(java.lang.String sequenceName)
```
    覆盖:
    
    getSequenceNextValString 在类中 org.hibernate.dialect.Dialect
  - getQuerySequencesString
```
public java.lang.String getQuerySequencesString()
```
    覆盖:
    
    getQuerySequencesString 在类中 org.hibernate.dialect.Dialect
  - getAddColumnString
```
public java.lang.String getAddColumnString()
```
    覆盖:
    
    getAddColumnString 在类中 org.hibernate.dialect.Dialect
  - getNullColumnString
```
public java.lang.String getNullColumnString()
```
    覆盖:
    
    getNullColumnString 在类中 org.hibernate.dialect.Dialect
  - qualifyIndexName
```
public boolean qualifyIndexName()
```
    覆盖:
    
    qualifyIndexName 在类中 org.hibernate.dialect.Dialect
  - getForUpdateString
```
public java.lang.String getForUpdateString()
```
    覆盖:
    
    getForUpdateString 在类中 org.hibernate.dialect.Dialect
  - supportsIdentityColumns
```
public boolean supportsIdentityColumns()
```
    覆盖:
    
    supportsIdentityColumns 在类中 org.hibernate.dialect.Dialect
  - getIdentitySelectString
```
public java.lang.String getIdentitySelectString()
```
    覆盖:
    
    getIdentitySelectString 在类中 org.hibernate.dialect.Dialect
  - getIdentityColumnString
```
public java.lang.String getIdentityColumnString()
```
    覆盖:
    
    getIdentityColumnString 在类中 org.hibernate.dialect.Dialect
  - supportsInsertSelectIdentity
```
public boolean supportsInsertSelectIdentity()
```
    覆盖:
    
    supportsInsertSelectIdentity 在类中 org.hibernate.dialect.Dialect
  - applyLocksToSql
```
public java.lang.String applyLocksToSql(java.lang.String arg0,
                                        java.util.Map arg1,
                                        java.util.Map arg2)
```
    覆盖:
    
    applyLocksToSql 在类中 org.hibernate.dialect.Dialect
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(java.sql.CallableStatement arg0,
                                         int arg1)
                                  throws java.sql.SQLException
```
    覆盖:
    
    registerResultSetOutParameter 在类中 org.hibernate.dialect.Dialect
    
    抛出:
    
    java.sql.SQLException
  - getResultSet
```
public java.sql.ResultSet getResultSet(java.sql.CallableStatement arg0)
                                throws java.sql.SQLException
```
    覆盖:
    
    getResultSet 在类中 org.hibernate.dialect.Dialect
    
    抛出:
    
    java.sql.SQLException
  - supportsCurrentTimestampSelection
```
public boolean supportsCurrentTimestampSelection()
```
    覆盖:
    
    supportsCurrentTimestampSelection 在类中 org.hibernate.dialect.Dialect
  - isCurrentTimestampSelectStringCallable
```
public boolean isCurrentTimestampSelectStringCallable()
```
    覆盖:
    
    isCurrentTimestampSelectStringCallable 在类中 org.hibernate.dialect.Dialect
  - supportsTemporaryTables
```
public boolean supportsTemporaryTables()
```
    覆盖:
    
    supportsTemporaryTables 在类中 org.hibernate.dialect.Dialect
  - generateTemporaryTableName
```
public java.lang.String generateTemporaryTableName(java.lang.String arg0)
```
    覆盖:
    
    generateTemporaryTableName 在类中 org.hibernate.dialect.Dialect
  - dropTemporaryTableAfterUse
```
public boolean dropTemporaryTableAfterUse()
```
    覆盖:
    
    dropTemporaryTableAfterUse 在类中 org.hibernate.dialect.Dialect
  - supportsEmptyInList
```
public boolean supportsEmptyInList()
```
    覆盖:
    
    supportsEmptyInList 在类中 org.hibernate.dialect.Dialect
  - supportsExistsInSelect
```
public boolean supportsExistsInSelect()
```
    覆盖:
    
    supportsExistsInSelect 在类中 org.hibernate.dialect.Dialect

类 SQLServer2012Dialect

字段概要

从类继承的字段 org.hibernate.dialect.SQLServer2005Dialect

从类继承的字段 org.hibernate.dialect.Dialect

构造器概要

方法概要

从类继承的方法 org.hibernate.dialect.SQLServer2005Dialect

从类继承的方法 org.hibernate.dialect.CTPSQLServerDialect

从类继承的方法 org.hibernate.dialect.SQLServerDialect

从类继承的方法 org.hibernate.dialect.Dialect

从类继承的方法 java.lang.Object

构造器详细资料

SQLServer2012Dialect

方法详细资料

getLimitString

useMaxForLimit

convertToFirstRowValue

supportsLimitOffset

supportsLimit

supportsVariableLimit

supportsSequences

supportsPooledSequences

getCreateSequenceString

getDropSequenceString

getSelectSequenceNextValString

getSequenceNextValString

getQuerySequencesString

getAddColumnString

getNullColumnString

qualifyIndexName

getForUpdateString

supportsIdentityColumns

getIdentitySelectString

getIdentityColumnString

supportsInsertSelectIdentity

applyLocksToSql

registerResultSetOutParameter

getResultSet

supportsCurrentTimestampSelection

isCurrentTimestampSelectStringCallable

supportsTemporaryTables

generateTemporaryTableName

dropTemporaryTableAfterUse

supportsEmptyInList

supportsExistsInSelect