[hibernate-dev] SQLServer getLimitString() refactoring
Łukasz Antoniak
lukasz.antoniak at gmail.com
Fri Jun 8 00:46:50 EDT 2012
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
More information about the hibernate-dev
mailing list