I'll test against 2000 and v7, but I don't have time to get a 2005 server running -- volunteers?
Rick
On 2/18/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
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
