manageremployeespackagebody.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 14 行

CREATE OR REPLACE PACKAGE BODY ManagerEmployeesPackage 
AS
   PROCEDURE usp_SelectManagerEmployees (inManagerID IN CHAR, 
      results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT UserID, FirstName || ' ' || LastName AS EmployeeName
      FROM Users
      Where ManagerID = inManagerID
      ORDER BY EmployeeName;
   END;
END;