请问如何简化下面的触发器?ALTER TRIGGER TriggerINCCount
ON dbo.DBRateProgram
FOR INSERT
AS
update DBProgram set CountOfPositive=CountOfPositive+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=0 update DBProgram set CountOfNeutral=CountOfNeutral+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=1
update DBProgram set CountOfNegative=CountOfNegative+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=2
ON dbo.DBRateProgram
FOR INSERT
AS
update DBProgram set CountOfPositive=CountOfPositive+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=0 update DBProgram set CountOfNeutral=CountOfNeutral+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=1
update DBProgram set CountOfNegative=CountOfNegative+1
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID
Where Inserted.RateType=2
解决方案 »
- Trigger有没办法弹出一个提示信息,然后数据仍可保存?
- select convert(datetime ,'2006-10-16')+convert(datetime,'10:31:16.258')的结果????
- 登陆的存储过程
- ~~~新手问题~~关于自动编号
- Report Manager为何不能使用了?
- 建立数据库时候时间的默认值怎么写?
- sqlserver 浮点型转为字符串
- 高分相送,see!!!!!!!!!。
- 程序代码和存储过程之间的权衡
- 请问oracle8.05如何卸载???
- 错误提示尚未注册 OLE DB 访问接口 "MICROSOFT.JET.OLEDB.4.0 "。
- 求一int型id是否在查询出来的一ID字符串中SQL?
ON dbo.DBRateProgram
FOR INSERT
AS
update DBProgram set
CountOfPositive = CASE Inserted.RateType when 0 then CountOfPositive+1 else CountOfPositive end,
CountOfNeutral = CASE Inserted.RateType when 1 then CountOfNeutral+1 else CountOfNeutral end,
CountOfNegative = CASE Inserted.RateType when 2 then thenCountOfNegative+1 else thenCountOfNegative end
From DBProgram
INNER JOIN Inserted
ON DBProgram.ProgramID = Inserted.ProgramID