Re: [hibernate-dev] SQLServer getLimitString() refactoring

Two more notes: 1. Maybe we could select columns without alias by number instead of adding "pageN" alias? Example: "SELECT rid1688_, 2, deviati16_1688_, 4, sortindex1688_ FROM query WHERE __hibernate_row_nr__ >= ? AND __hibernate_row_nr__ < ?". Will have to check if SQL Server supports such syntax in the SELECT clause. 2. As you mentioned, AS is optional keyword. Regards, Lukasz