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