[freetds] Again about rows count

Velichko Yuriy velichko.yuriy at gmail.com
Fri Sep 20 08:20:54 EDT 2013


Thanks for respond!


On 20 September 2013 15:16, Frediano Ziglio <freddy77 at gmail.com> wrote:

> 2013/9/20 Velichko Yuriy <velichko.yuriy at gmail.com>:
> > Helo!
> >
> > I need to figure out the number of records returned from SELECT query,
> > before start fetching data [MSSQL Server].
> >
> > In the mail archive I found similar questions like this
> >
> > http://marc.info/?l=freetds&m=107514963123856
> >
> > So as I understood the server did not support this feature.
> >
> > These letters are quite old. Is the situation is not changed? There is no
> > way to get count of affected rows before fetching data?
> >
>
> The protocol does not allow this. Still newer protocol.
>
> What you can do is open a server side cursor, fetch row cound and than
> read rows.
>
> Frediano
>
> > Thanks!
> > --
> > Best Regards!
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Best Regards!


More information about the FreeTDS mailing list