求一个留言回复的触发器的写法

[snoopy83101]

留言主内容表 [M_Meassage]其中有一int列[Rcount]来表示回复数

留言回复表[M_Reply]其中有一列是[mid]与内容表[Meassage]的主键[Id]关联

功能是这样的:
当回复表[M_Reply]增加回复的时候...相对应[M_Meassage]中的回复数[Rcount]做加法运算.
当回复表[M_Reply]删除回复的时候...相对应[M_Meassage]中的回复数[Rcount]做减法运算.

不论是删除或者增加多少条都不出错.应该怎么写呀???

先谢谢大家!

[snoopy83101]

顶起,等人..

[ljb0901]

以下是增加
CREATE TRIGGER InsertFile
ON [M_Reply]
FOR insert
AS
BEGIN
update [M_Meassage] set Rcount=Rcount+1
END
GO
以下是删除
CREATE TRIGGER InsertFile
ON [M_Reply]
FOR delete
AS
BEGIN
update [M_Meassage] set Rcount=Rcount-1
END
GO

[insus]

能用存储过程,不必用触发器:

如下:
CREATE PROCEDURE usp_M_Reply_Insert
...
AS
INSERT INTO [M_REply](...)VALUES (...);
UPDATE [M_Message] SET [Rcount] =[Rcount] +1 WHERE ....



CREATE PROCEDURE usp_M_Reply_Delete
AS
DELETE FROM [M_Reply] WHERE ...
UPDATE [M_Message] SET [Rcount] =[Rcount] +1 WHERE ....