Re: [Sqlalchemy-users] LIMIT vs TOP

[Michael Bayer]

OK then, your ansisql patch is committed.  we'll go with the simpler method for now.  we can do version checks later on to support conditions for using ROW_NUMBER...do we have a newer MS-SQL server to test that with ? as for the OFFSET stuff, I would rather not build in "row consumption" as an extension to a particular kind of query, particularly since that totally breaks in the case of  subqueries that specify OFFSET, as is the case with an eager-loading mapper that selects with an "offset" or "limit" parameter.  I vote for raising the exception right now, so that an application can choose to define whatever scheme it wants to deal with that, but none by default. On Feb 18, 2006, at 5:03 PM, Rick Morrision wrote: Well, that won't work in pre-2005 SQL server, which are bound to be the overwhelming majority for the next few years. Perhaps we can check @@DBVERSION and act appropriately depending on the version, or make the 2005 version a different module (anybody know if pymssql / FreeTDS even works with MSSQL 2005?) Rick On 2/18/06, Michael Bayer <[EMAIL PROTECTED]> wrote: On Feb 18, 2006, at 3:28 PM, Daniel Miller wrote: > > Note that SQL Server 2005 has ROW_NUMBER() OVER(ORDER BY ...) > More here: http://sqljunkies.com/WebLog/amachanic/archive/ > 2004/11/03/4945.aspx > news # 1 -         MSSQL == Microsoft SQL Server !  (i was thinking of MSQL...) news # 2 -         SQLAlchemy/oracle's LIMIT/OFFSET is using ROW_NUMBER() OVER (ORDER BY) to get both LIMIT and OFFSET.  shall we just copy oracle.py's code to this new MSSQL module ? ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems?  Stop!  Download the new AJAX search engine that makes searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users