搞定了,谢谢各位!
下面是我写的,希望对后来人有所帮助:
IF UPDATE(userId) OR UPDATE(password_)
if exists(select * from inserted where passwordEncrypted=0)
begin
insert into User_change_info
(A,
B,
C,
D,
E
) select
ins.A,
ins.B,
del.C,
ins.E + ins.F + ins.G,
'test',
from inserted ins,deleted del;
end