you could use this with an Nhibernate SqlQuery since that is raw sql. but that ties you to a specific database. this may not be a problem for you application or testing.
On Oct 22, 8:08 pm, Fabio Maulo <[email protected]> wrote: > No > > -- > Fabio Maulo > > El 22/10/2010, a las 16:08, Brian DeMarzo <[email protected]> escribió: > > > MSSQL 2000 and higher offers a useful "WITH TIES" statement that can > > be inserted into SELECT TOP queries, ensuring that the "top" includes > > ties. From the SQL documentation (http://msdn.microsoft.com/en-us/ > > library/aa259187%28SQL.80%29.aspx): > > > WITH TIES > > > Specifies that additional rows be returned from the base result set > > with the same value in the ORDER BY columns appearing as the last of > > the TOP n (PERCENT) rows. TOP ...WITH TIES can only be specified if an > > ORDER BY clause is specified. > > > Is there any equivalent of this in NHibernate (in HQL or otherwise)? > > > Thanks! > > > - b > > > -- > > You received this message because you are subscribed to the Google Groups > > "nhusers" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
