managerspackagebody.sql

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

CREATE OR REPLACE PACKAGE BODY ManagersPackage 
AS
   PROCEDURE usp_SelectManagers (results_cursor OUT CURSOR_TYPE)
   AS
   BEGIN
      OPEN results_cursor FOR
      SELECT UserID AS ManagerID, FirstName || ' ' || LastName AS ManagerName
      FROM Users
      JOIN Roles ON Users.RoleID = Roles.RoleID
      WHERE UPPER(RoleName) LIKE '%MANAGER%';
   END;
END;