触发器更新

liyihongcug

sqlserver的触发器很好用 可以disable enable
create TRIGGER [dbo].[cModified]
   ON  [dbo].[c]
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)