[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