How to implement TOP for SQL Server

[theronic]

SQL Server does not support LIMIT and OFFSET, but it does support TOP at the start of a SELECT statement, e.g. SELECT TOP 500 * FROM Table

I looked at the limit fn that implements LIMIT with assoc-op, but I'm not sure how to extend SQLingvo to support the TOP statement at the start of the query?

[r0man]

Sorry, this is not supported at the moment ...