FreeTDS Development Group

["Brian Bruns" <camber AT ais.org>]

At the TDS level, the results stream has a results token (or colnames,
colinfo under TDS 4.2), followed by 0 or more rows, followed by a DONE
token (DONE, DONEPROC).   This is a simplification, there can be message
tokens, return status token, computes, etc... as well.  In the done token
one of the fields specifies whether more results are coming.  Basically if
the flag is set the client should expect another set of result, row, done
tokens until the flag is not set. Check tds_process_end() in token.c for
details.

Brian

> Hello !
> 
>    I don't understand how can I use multi statement in MSSQL - how does it
> work. In other SQL databases - the first, I create database connection
> handle, than, I can create transaction handle based on database connection
> handle, than I can use many statement handle base on transaction handle at
> the same time.
> 
>    So, I can start 'select ...', than fetch some rows, start another
> 'select ...' and fetch from the first statement and from the second
> statement at the same time.
> 
>    How does it implement in TDS level ? I need to create new connection to
> SQL Server to start new statement, isn't it ?
> 
> Best regards, Nil.
> E-Mail: nil AT internet2.ru