Re: Again about rows count
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4d9N1T4Tw6s26cyV75yTOG+L8+SFXJfdbMUaMh-rTPu0g@mail.gmail.com> |
2013/9/20 Velichko Yuriy <[email protected]>: > 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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds