Listing 7 shows an example of a stored procedure that determines an employee's new salary and bonus, depending on their performance rating.
清单7展示了一个存储过程的例子，该存储过程根据业绩评分评定雇员新的工资和奖金。
2
This stored procedure accepts two input parameters, the employee number and a rating, then updates the employee's salary and bonus depending on the rating given.
该存储过程接受两个输入参数，即雇员号和一个评分，然后根据给定的评分更新该雇员的工资和奖金。
3
Finance shall maintain a spreadsheet (updated monthly) that details every eligible employee's Deferred Retention Bonus Plan accruals.