Skip to Content.
Sympa Menu

freetds - Re: Multi statement SQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Brian Bruns" <camber AT ais.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Multi statement SQL
  • Date: Wed, 8 Nov 2000 12:51:58 -0500


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



  • Multi statement SQL, Nil Alexandrov, 11/08/2000
    • <Possible follow-up(s)>
    • Re: Multi statement SQL, Brian Bruns, 11/08/2000

Archive powered by MHonArc 2.6.24.

Top of Page