自己写的第一个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?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!