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

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

Syntax

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

Field Value

true

See Also