"UpdateUser" 存储过程

描述:

This 存储过程 updates the settings for a user in the database. The input parameters include UserID, Email and Password.

定义:

    
    CREATE PROCEDURE UpdateUser
    (
        @UserID      int,
        @Email       nvarchar(100),
        @Password    nvarchar(20)
    )
    AS

    UPDATE
        Users

    SET
        Email    =   @Email,
        Password =   @Password

    WHERE
        UserId    =  @UserID

使用的数据库中的表:

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