"GetUsers" Stored Procedure

Description:

This stored procedure returns the UserID, Name and Email for all registered users.

Definition:

    
   CREATE PROCEDURE Portal_GetUsers
   AS
   
   SELECT  
       UserID,
       Email
   
   FROM Portal_Users
       
   ORDER BY Email

Database Tables Used:

Users: Each record in the Users table is a unique user identity. The primary key in this table is the UserID identity field.