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 |
