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
表中对应的字段中