自己写的第一个SQLSERVER2005触发器

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================

alter TRIGGER tr_stuffUser
   ON  stuffUser
 AFTER
   insert,update
AS
if exists(select * from inserted)
begin
 update stuffuser set firsttime=inserted.latestlogintime from inserted
 where stuffuser.stuffuserid=inserted.stuffuserid and
 (stuffuser.firsttime='' or stuffuser.firsttime is null); 
end
update stuffuser set lasttime=inserted.latestlogintime from inserted
where stuffuser.stuffuserid=inserted.stuffuserid;

GO