SQL Server论坛楼层计算触发器

9/1/2015来源:SQL技巧人气:1086

SQL Server论坛楼层计算触发器

代码:

USE suya_devGOIF EXISTS(    SELECT *    FROM sys.triggers    WHERE name = N'BBS_Post_before_insert')    DROP TRIGGER BBS_Post_before_insert GOCREATE TRIGGER BBS_Post_before_insert     ON BBS_Post    FOR insertAS BEGIN   declare @Id int    declare @TopicId int   declare @Floor int   select @Id = Id from inserted   select @TopicId = TopicId from inserted   select @Floor = count(1) from BBS_Post where TopicId=@TopicId   update BBS_Post set Floor=@Floor where Id=@IdENDGO
View Code