K>SET QUOTED_IDENTIFIER ON 
K>GO
K>SET ANSI_NULLS ON 
K>GO

K>ALTER  PROCEDURE sp_manyresultsets
K>    (
K>        @Id int
K>    )
K>AS
K>    SET NOCOUNT ON

K>-- First Select
K>    SELECT     *
K>    FROM      table1
        
K>-- Second Select
K>    SELECT     *
K>    FROM      table2
         
K>    RETURN 0

K>GO
K>SET QUOTED_IDENTIFIER OFF 
K>GO
K>SET ANSI_NULLS ON 
K>GO
K>

K>Connection conn = null;
K>// skip get connection
K>CallableStatement cs = null;
K>ResultSet rs = null;
K>int id = 0;
K>try{
K>  cs = conn.prepareCall("{call sp_manyresultsets(?)}");
K>  cs.setInt(1,id);
K>  cs.execute();
K>  // retrieve first ResultSet (select * from table1)
K>  rs = cs.getResultSet();
K>  if (cs.getMoreResults()) { // check if we have more returned ResultSets
K>  // retrieve second ResultSet (select * from table2)
K>    rs = cs.getResultSet();
K>  }
K>}catch(SQLException sqle){

K>}finally{
K>try{
K>rs.close();                    
K>}catch(Exception e1){}                                
K>try{
K>cs.close();                    
K>}catch(Exception e1){}                                
K>}
K>