-- apps_master.sp_UpdatePassword (PROCEDURE) begin UPDATE m_user1 SET UserPassword = pass, LastUpdated = NOW(), UpdatedBy = id WHERE UserName = nameUser AND UserID = id AND ActiveYN = 'Y'; end