数据库触发器怎么写

[shenhaibb_]

select order_id,sum(product_price*orderitem_pro_num) as order_price
from orderitem as oi,product as p
where oi.product_id=p.product_id
group by order_id

写了一段sql代码 是用来求一个订单的总金额的 这个可以运行 可是我要怎么在触发器里设置呢 我想要 一更新字段 表中就有数据

[shenhaibb_]

救救

[小野马1209]

CREATE TRIGGER [trXXX]  --触发器名
ON Table  --表名
AFTER INSERT, UPDATE
AS
    BEGIN
    --写入想处理的语法即可
        INSERT INTO descTable(xxx, yyy, zzz)
        SELECT  xxx, yyy, zzz
        FROM    inserted i
        WHERE   i.yyy = 0
                AND   NOT EXISTS (SELECT    1 FROM  descTable d INNER JOIN inserted ii ON d.somecol = ii.somecol);
    END;

[小野马1209]

这个是我之前用过的，替换下语法就好

[shenhaibb_]

引用 2 楼 kaijie_wu1209 的回复:

CREATE TRIGGER [trXXX]  --触发器名
ON Table  --表名
AFTER INSERT, UPDATE
AS
    BEGIN
    --写入想处理的语法即可
        INSERT INTO descTable(xxx, yyy, zzz)
        SELECT  xxx, yyy, zzz
        FROM    inserted i
        WHERE   i.yyy = 0
                AND   NOT EXISTS (SELECT    1 FROM  descTable d INNER JOIN inserted ii ON d.somecol = ii.somecol);
    END;

...看..看不太懂