#  Update a Role
# Shameema Esufali June 2020

# Change this to your PersonnelID from the Personnel Table. 

SET @oldrole="Test Role 2", @newrole="Geographer";

  
#  Update a role 

UPDATE RoleReference SET Description =@newrole WHERE Description = @oldrole;  
