"GetUsers" 存储过程

描述:

This 存储过程 returns the UserID, Name and Email for all registered users.

定义:

    
    CREATE PROCEDURE GetUsers
    AS

    SELECT  
        UserID,
        Name,
        Email

    FROM
        Users
        
    ORDER BY 
        Email, Name

使用的数据库中的表:

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