Re: MS-SQL server LIMIT/OFFSET implementation

2006-07-21 Thread Dan Hristodorescu
that kind of query to achieve at least some decent performance.Regards,Dan. On 7/21/06, DavidA <[EMAIL PROTECTED]> wrote: > > On Thu, 2006-07-20 at 17:34 -0400, Dan Hristodorescu wrote:> > >> > > and for SQL 2000 should look like this:> > >> > > SEL

Re: MS-SQL server LIMIT/OFFSET implementation

2006-07-20 Thread Dan Hristodorescu
and the ORDER BY. Having those accessible it becomes a simple matter of a different assembly of the final SELECT string.I will wait for the new code to be committed.Regards,Dan.  On 7/20/06, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: On Thu, 2006-07-20 at 17:34 -0400, Dan Hristodorescu wrote:>

Re: MS SQL Server access from Linux/ODBC?

2006-07-20 Thread Dan Hristodorescu
Hi Filipe,Have you tried this?http://www.egenix.com/files/python/mxODBC.htmlFor commercial use you might have to pay for it but should run on Linux. There is also this one (SWIG based):https://sourceforge.net/projects/pyodbI cannot say anything about any of them, at work I'm forced  to use Windows