"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.