• FYI, this trigger will fail if more than one row is updated with the update query because a select into a scalar variable cannot result in more than one value.