SQL Server论坛楼层计算触发器

USE suya_dev
GO

IF EXISTS(
    SELECT *
    FROM sys.triggers
    WHERE name = N‘BBS_Post_before_insert‘
)
    DROP TRIGGER BBS_Post_before_insert 
GO

CREATE TRIGGER BBS_Post_before_insert 
    ON BBS_Post
    FOR insert
AS 
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=@Id
END
GO