jdbc 的实例源码

				
				DROP PROCEDURE multi_sample
				GO
				
				CREATE PROCEDURE multi_sample
				AS
				BEGIN
				
				  /* Result Set 1 */
				  SELECT product, "EXPENSIVE FOOD" category
				    FROM food
				    WHERE price >= $100.00
				    ORDER BY product
				
				  /* Result Set 2 */
				  SELECT product, "CHEAP FOOD" category
				    FROM food
				    WHERE price < $100.00
				    ORDER BY product
				
				END
				GO