CREATE TRIGGER [UPDATEYourTable] ON [dbo].[YourTableName] AFTER UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here IF UPDATE(Col1) OR UPDATE(Col2) OR UPDATE(列3名称) BEGIN UPDATE dbo.FRE SET Col5 = Col5 + 1 ENDENDCREATE TRIGGER [INSERTYourTable] ON [dbo].[YourTable] AFTER INSERT AS BEGIN -- 插入的话,跟列没关系,直写代码就是了 END
CREATE TRIGGER [UPDATEYourTable]
ON [dbo].[YourTableName]
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; -- Insert statements for trigger here
IF UPDATE(Col1) OR UPDATE(Col2) OR UPDATE(列3名称)
BEGIN
UPDATE dbo.FRE SET Col5 = Col5 + 1
ENDENDCREATE TRIGGER [INSERTYourTable]
ON [dbo].[YourTable]
AFTER INSERT
AS
BEGIN
-- 插入的话,跟列没关系,直写代码就是了
END