liyihongcug 发表于 2011-03-25 19:42

触发器更新

sqlserver的触发器很好用 可以disable enable
create TRIGGER .
   ON.
aFTER UPDATE
AS
BEGIN
        -- added to prevent extra result sets from interfering with selects
        SET NOCOUNT ON;
        UPDATE c SET Modified=getdate() WHERE ID IN (SELECT ID FROM Inserted)
页: [1]
查看完整版本: 触发器更新