SqlServerDialect should support SQL 2000 which does not support the row_number function

Description

As a fix to a patch has been applied to SQLServerDialect that make use of the row_number function for paged results. As I can see from the comments of SQLServerDialect, this dialect should be fine for sql server 2000, but sql server 2000 does not support row_number function.

There should be a new dialect that extends the SQLServerDialect one which will add support for paged results throw the row_number function.

Environment

None

Assignee

Strong Liu

Reporter

GeorgiosV

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure