你的位置:首页 > 数据库

[数据库]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