泛微OA 数据库内insert、update触发器

文章描述了两个SQL触发器:trg_insert_data和trg_update_data,它们在uf_xrwmk表进行数据插入和更新后,自动将新数据复制到uf_rwgzmk表中特定字段。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

CREATE TRIGGER trg_insert_data
ON uf_xrwmk
AFTER INSERT
AS
BEGIN
    INSERT INTO uf_rwgzmk (duty_officer, task, scheduled_start_time, scheduled_end_time, task_state, task_class, actual_start_time, actual_end_time, rummager, inspect_start_time, inspect_end_time, inspect_state ,inspect_result, formmodeid, modedatacreater, modedatacreatertype, MODEUUID, form_biz_id)
    SELECT duty_officer, inserted.ID, scheduled_start_time, scheduled_end_time, task_state , task_class, actual_start_time, actual_end_time, rummager, inspect_start_time, inspect_end_time, inspect_state ,inspect_result, 86, 1, 0, 'a50bd99f-b739-4b6e-8055-530c887aab3c', 17000280
    FROM inserted;
END;
CREATE TRIGGER trg_update_data
ON uf_xrwmk
AFTER UPDATE
AS
BEGIN
    INSERT INTO uf_rwgzmk (duty_officer, task, scheduled_start_time, scheduled_end_time, task_state, task_class, actual_start_time, actual_end_time, rummager, inspect_start_time, inspect_end_time, inspect_state ,inspect_result, formmodeid, modedatacreater, modedatacreatertype, MODEUUID)
    SELECT duty_officer, task, scheduled_start_time, scheduled_end_time, task_state , task_class, actual_start_time, actual_end_time, rummager, inspect_start_time, inspect_end_time, inspect_state ,inspect_result, 86, 1, 0, 'a50bd99f-b739-4b6e-8055-530c887aab3c'
    FROM inserted;
END;

这个触发器将在每次向uf_xrwmk表插入数据后自动执行,并将新插入的数据复制到uf_rwgzmk表中对应的字段中

评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值