multi_sample.sp.unix

来自「有关JDBC的使用一些编程实例,有关与数据库连接的代码」· UNIX 代码 · 共 24 行

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