触发器样本

ALTER TRIGGER [dbo].[T_Test01] --触发器名称

ON [dbo].[Test01] --对应的触发的表名

for INSERT --触发条件

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

declare @id int;

set @id=(select id from inserted);

update Test01 set T3=555 where id =@id --具体语句

-- Insert statements for trigger here

END