net.sf.hibernate.dialect
Class SQLServerDialect

java.lang.Object
  extended bynet.sf.hibernate.dialect.Dialect
      extended bynet.sf.hibernate.dialect.SybaseDialect
          extended bynet.sf.hibernate.dialect.SQLServerDialect

public class SQLServerDialect
extends SybaseDialect

A dialect for Microsoft SQL Server 2000

Author:
Gavin King

Field Summary
 
Fields inherited from class net.sf.hibernate.dialect.Dialect
CLOSED_QUOTE, QUOTE
 
Constructor Summary
SQLServerDialect()
           
 
Method Summary
 boolean bindLimitParametersFirst()
          Does the LIMIT clause come at the start of the SELECT statement, rather than at the end?
 String getLimitString(String querySelect, boolean hasOffset, int limit)
           
 boolean supportsLimit()
          Does this Dialect have some kind of LIMIT syntax?
 boolean supportsLimitOffset()
          Does this dialect support an offset?
 boolean supportsVariableLimit()
           
 boolean useMaxForLimit()
          Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?
 
Methods inherited from class net.sf.hibernate.dialect.SybaseDialect
closeQuote, getAddColumnString, getIdentityColumnString, getIdentitySelectString, getNoColumnsInsertString, getNullColumnString, openQuote, qualifyIndexName, supportsForUpdate, supportsIdentityColumns
 
Methods inherited from class net.sf.hibernate.dialect.Dialect
bindLimitParametersInReverseOrder, createCaseFragment, createOuterJoinFragment, dropConstraints, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCreateSequenceString, getDefaultProperties, getDialect, getDialect, getDropSequenceString, getFunctions, getIdentityInsertString, getLimitString, getLowercaseFunction, getQuerySequencesString, getSchemaSeperator, getSequenceNextValString, getTypeName, getTypeName, hasAlterTable, registerColumnType, registerColumnType, registerFunction, supportsForUpdateNowait, supportsForUpdateOf, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsSequences, supportsUnique, toString
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

SQLServerDialect

public SQLServerDialect()
Method Detail

bindLimitParametersFirst

public boolean bindLimitParametersFirst()
Description copied from class: Dialect
Does the LIMIT clause come at the start of the SELECT statement, rather than at the end?

Overrides:
bindLimitParametersFirst in class Dialect
Returns:
true if limit parameters should come before other parameters

getLimitString

public String getLimitString(String querySelect,
                             boolean hasOffset,
                             int limit)
Overrides:
getLimitString in class Dialect

supportsLimit

public boolean supportsLimit()
Description copied from class: Dialect
Does this Dialect have some kind of LIMIT syntax?

Overrides:
supportsLimit in class Dialect

useMaxForLimit

public boolean useMaxForLimit()
Description copied from class: Dialect
Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

Overrides:
useMaxForLimit in class Dialect

supportsLimitOffset

public boolean supportsLimitOffset()
Description copied from class: Dialect
Does this dialect support an offset?

Overrides:
supportsLimitOffset in class Dialect

supportsVariableLimit

public boolean supportsVariableLimit()
Overrides:
supportsVariableLimit in class Dialect