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 = @UserIDDatabase 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.