| 单词 | jobhist | ||||||||
| 释义 |
|
当插入一条新的雇员记录时，触发器向表jobhist增加一条关于这个雇员信息的新记录。 enterprisedb.com | When a new employee row is inserted, the trigger adds a new row to the jobhist table for that employee. enterprisedb.com |
表jobhist的内容显示了对于所操作每一条记录的触发器动作-插入两条新雇员记录的雇佣记录和在2条雇员记录上改变佣金的记录。 enterprisedb.com | The contents of the jobhist table shows the [...] action of the trigger for each affected row - two new hire entries for the two [...]new employees and two changed commission records for the updated commissions on the two employees. enterprisedb.com |
在下面的示例中显示了如何为表jobhist中每一条记录添加一个序列数。 enterprisedb.com | The following example shows how a sequence number can be added to every row in thejobhist table. enterprisedb.com |
当更新已存在的雇员记录时，触发器把这个雇员最近一条在表jobhist中记录（假定enddate列的值为空）中enddate列的值设置为当前日期，并且向表jobhist中插入一条雇员新信息的记录。 enterprisedb.com | When an existing employee is updated, the trigger sets the enddate [...] column of the latest jobhistrow (assumed to be the one with a null enddate) to the current date and inserts a new jobhistrowwith the employee’s [...]new information. enterprisedb.com |
英汉双解词典包含2273206条英汉词条，基本涵盖了全部常用单词的翻译及用法，是英语学习的有利工具。