sql 在更新某字段后写入日志触发器

初次运行用CREATE TRIGGER [upUserInfo_dml] set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [upUserInfo_dml] ON [dbo].[userInfo] AFTER UPDATEAS begin declare @tn int declare @zd varchar(20) declare @uz varchar(20) select @tn=userId,@zd=loginName,@uz=loginPass from inserted if update ([loginName]) begin insert [dbo].[upLog] select @tn,@zd,@uz --INSERT into [dbo].[upLog] ([userid],[logname],[logpas]) VALUES(@tn,@zd,@uz) endend