[freetds] call a stored procedure and tds_submit_query
Thompson, Bill D (London)
bill_d_thompson at ml.com
Fri Jul 23 06:07:20 EDT 2004
Yes you can do this - you would just construct a statement "exec sp_myproc
@parameter = 'value'" and submit it as you would a "select * from mytable"
or "update mytable set column = 'value'" statement.
If the stored procedure returns a result set, then it can be processed just
as if it were the result set from a "select * from mytable" statement.
The only proviso is with stored procedure OUTPUT parameters.
If you are talking to sql server 2000 sp3, then these will not be returned
to the client.
From: Fabrizio Taretto [mailto:fabrizio.taretto at sinedita.it]
Sent: 23 July 2004 10:58
To: freetds at lists.ibiblio.org
Subject: [freetds] call a stored procedure and tds_submit_query
someone can tell me if it's possible call a stored procedure with
tds_submit_query and process result with tds_process_result_tokens.
These functions are perfect for SELECT and UPDATE but what can I use
for a stored procedure?
Can anybody help me?
I'm work on MacOS X 10.3.4.
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
If you are not an intended recipient of this e-mail, please notify
the sender, delete it and do not read, act upon, print, disclose,
copy, retain or redistribute it.
Click here for important additional terms relating to this e-mail.
More information about the FreeTDS