Vishu Singhvi Vishu Singhvi - 22 days ago 6
Java Question

Queries returning multiple result sets

I have a

MSSQL
database and am running the following query:

select * from projects; select * from user


The above query returns two result sets at once, and I cannot fire both queries separately. How can I handle both the result set at once in a Java class?

Answer

The answer: it is NOT possible. The only way: Run them as separate queries.