This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
Performance when mutiple resultsets are returned from a stored procedure ?
posted 14 years ago
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