代码:USE suya_devGOIF EXISTS( SELECT * FROM sys.triggers WHERE name = NBBS_Post_before_insert) DROP TRIGGER BBS_Post_before_insert GOCRE ...
代码:
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
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:论坛楼层计算触发器
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。