The MsSql2005Dialect type exposes the following members.

Properties

  NameDescription
AddColumnString
(Inherited from MsSql2000Dialect.)
BindLimitParametersFirst
Does the LIMIT clause come at the start of the SELECT statement rather than at the end?
(Inherited from Dialect.)
BindLimitParametersInReverseOrder
Does the LIMIT clause specify arguments in the "reverse" order limit, offset instead of offset, limit?
(Inherited from Dialect.)
CascadeConstraintsString
Completely optional cascading drop clause
(Inherited from Dialect.)
CloseQuote
(Inherited from MsSql2000Dialect.)
DefaultProperties
Retrieve a set of default Hibernate properties for this database.
(Inherited from Dialect.)
DropConstraints
Do we need to drop constraints before dropping tables in the dialect?
(Inherited from Dialect.)
ForUpdateNowaitString
Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect
(Inherited from Dialect.)
ForUpdateOfColumns (Inherited from Dialect.)
ForUpdateString (Inherited from MsSql2000Dialect.)
Functions
Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!
(Inherited from Dialect.)
HasAlterTable
Does this dialect support the ALTER TABLE syntax?
(Inherited from Dialect.)
HasDataTypeInIdentityColumn
Whether this dialect has an identity clause added to the data type or a completely seperate identity data type.
(Inherited from Dialect.)
IdentityColumnString
(Inherited from MsSql2000Dialect.)
IdentityInsertString
The keyword used to insert a generated value into an identity column (or null)
(Inherited from Dialect.)
LowercaseFunction
The name of the SQL function that transforms a string to lowercase
(Inherited from Dialect.)
MaxAliasLength (Inherited from Dialect.)
MultipleQueriesSeparator
How we seperate the queries when we use multiply queries.
(Inherited from Dialect.)
NoColumnsInsertString
(Inherited from MsSql2000Dialect.)
NullColumnString
(Inherited from MsSql2000Dialect.)
OpenQuote
(Inherited from MsSql2000Dialect.)
QualifyIndexName
(Inherited from MsSql2000Dialect.)
SupportsIdentityColumns
(Inherited from MsSql2000Dialect.)
SupportsIfExistsAfterTableName
Does the dialect support the syntax 'drop table NAME if exists'
(Inherited from Dialect.)
SupportsIfExistsBeforeTableName
Does the dialect support the syntax 'drop table if exists NAME'
(Inherited from Dialect.)
SupportsLimit
Sql Server 2005 supports a query statement that provides LIMIT functionality.
(Overrides MsSql2000Dialect..::.SupportsLimit.)
SupportsLimitOffset
Sql Server 2005 supports a query statement that provides LIMIT functionality with an offset.
(Overrides MsSql2000Dialect..::.SupportsLimitOffset.)
SupportsSequences
Does this dialect support sequences?
(Inherited from Dialect.)
SupportsSubSelects
Does this dialect support subselects?
(Inherited from Dialect.)
SupportsUnique
Does this dialect support the UNIQUE column syntax?
(Inherited from Dialect.)
SupportsVariableLimit
Can parameters be used for a statement containing a LIMIT?
(Inherited from MsSql2000Dialect.)
TimestampResolutionInTicks (Inherited from MsSql2000Dialect.)
UseMaxForLimit
Sql Server 2005 supports a query statement that provides LIMIT functionality with an offset.
(Overrides MsSql2000Dialect..::.UseMaxForLimit.)

See Also