sql server 触发器
触发器样本
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
更多精彩
