multi_sample.sp.win32

有关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