sql server 触发器

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

sql server 触发器

标签：result   lte   trigger   rev   int   dde   extra   where   名称