Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: Multiple data sets in MySQL stored procedures

by mpeppler (Vicar)
on Apr 10, 2007 at 17:09 UTC ( #609213=note: print w/ replies, xml ) Need Help??


in reply to Re: Multiple data sets in MySQL stored procedures
in thread Multiple data sets in MySQL stored procedures

There are situations where a stored proc that returns multiple result sets makes a lot of sense.

Then there is the Sybase way, where not only stored procs, but normal SQL batches including lots of requests can be sent to the dataserver with one single request, followed by a simple loop to fetch the results.

This makes client-side programming elegant, as I can throw a Transact-SQL block with IF and WHILE clauses at the server and not have to add any special code to handle it.

Michael


Comment on Re^2: Multiple data sets in MySQL stored procedures

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://609213]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2014-09-22 21:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (205 votes), past polls