This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Hi, I have got a stored procedure where I want to put a number of SELECT queries. And each SELECT query must return one Resultset. Hence, finally, the stored procedure will have to return multiple resultsets. My database is SQL Server 7.0. I want to know if this can de done using JDBC. If so, can anyone tell me the performance related to this implementation ? Will if improve the performance or will it hamper it ?? Thanks, Pritam
subject: Performance when mutiple resultsets are returned from a stored procedure ?