我这个触发器这样写对不对啊??? create trigger meetingremarks on meeting after insert as begin update workflow_form set remark=workflow_form.marks from workflow_form a,inserted b where a.requestid=b.requestid end ---------------------------------------------- 我想创建一个触发器,在表Meeting插入新行的时候生效,做如下步骤: 表Meeting插入新行后,给所插入的新行里面的remark字段赋值表workflow_form中marks字段的值(这两个表的主键都是requestid字段,并且相关联) 话说我这样写对不对啊?
------解决方案--------------------
create trigger meetingremarks on meeting after insert as begin update workflow_form set remark=a.marks from workflow_form a,inserted b where a.requestid=b.requestid end
------解决方案--------------------