# "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 Portal_UpdateUser
       (
           @UserID        int,
           @Email           nvarchar(100),
           @Password    nvarchar(50)
       )
       AS

       UPDATE Portal_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.