multi_sample.sp.win32

来自「jdbc 的实例源码」· WIN32 代码 · 共 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