if ((exists (select 1 from inserted)) and (exists (select 1 from deleted)))


else if (exists (select 1 from inserted) and not exists (select 1 from deleted))


else if (not exists (select 1 from inserted) and exists (select 1 from deleted))


if((select count(*) from inserted a inner join deleted b on a.ADAccount = b.ADAccount and a.IsDefaultScore <> b.IsDefaultScore)>0)

ADAccount 是主键

IsDefaultScore 是判断是否有改变的列