Skip to Content.
Sympa Menu

freetds - Re: [freetds] Again about rows count

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Again about rows count
  • Date: Fri, 20 Sep 2013 13:16:19 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page