برای نوشتن Trigger میبایست ابتدا یک صفحه SqlQuery باز نمایید در
Sqlserver 2008
عکسهای ضمینه دقت کنید
کد مثال
USE [sde]
GO
/****** Object: Trigger [dbo].[UPDATEFI] Script Date: 07/11/2010 16:04:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER TRIGGER [dbo].[UPDATEFI]
ON [dbo].[tblNormalConsumers]
AFTER INSERT,DELETE,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
UPDATE dbo.tblNormalConsumers
SET PH=N.ph ,PHF=n.PHF
FROM
-- Insert statements for trigger here
code
END