17 Trigger korrigieredegradierung create trigger korrigieredegradierung on Professoren after update as if update(Rang) begin update professoren set rang = d.rang from professoren p, deleted d where p.persnr = d.persnr and p.rang < d.rang end
{}