USE [DNWorld]
go
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
go
CREATE trigger [dbo].[t_UpdateMissionScore_BugFix]
on [dbo].[CharacterStatus]
after update
as
if update ([MissionScore])
update dbo.CharacterStatus set MissionScore=0 where MissionScore>0;
go