Re: [Sqlalchemy-users] LIMIT vs TOP

[Rick Morrision]

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