"UpdateUser" Stored Procedure

Description:

This stored procedure updates the settings for a user in the database. The input parameters include UserID, Email and Password.

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

    UPDATE
        Users

    SET
        Email    =   @Email,
        Password =   @Password

    WHERE
        UserId    =  @UserID
        
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.