Sql Server 2005 supports a query statement that provides LIMIT functionality with an offset.

Namespace:  NHibernate.Dialect
Assembly:  NHibernate (in NHibernate.dll)

Syntax

Visual Basic (Declaration)
Public Overrides ReadOnly Property SupportsLimitOffset As Boolean
C#
public override bool SupportsLimitOffset { get; }
Visual C++
public:
virtual property bool SupportsLimitOffset {
	bool get () override;
}
JavaScript
function get_supportsLimitOffset();

Field Value

true

See Also