SQL触发器trigger和网络路由tracert学习随笔

-- =============================================
-- Author:		<alex>
-- Create date: <20151014>
-- Description:	<删除触发器>
-- =============================================
ALTER trigger  trig_update_userLog ON dbo.UserLog
after insert, update, delete
AS
BEGIN
	IF ((exists (select 1 from inserted)) and (exists (select 1 from deleted)))
    BEGIN
		--更新
		INSERT UserLog_bak([username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate])
		SELECT [username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate] FROM deleted
    END
    else if (exists (select 1 from inserted) and not exists (select 1 from deleted))
    BEGIN
		--插入
		INSERT UserLog_bak([username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate])
		SELECT [username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate] FROM inserted
    end
    else if (not exists (select 1 from inserted) and exists (select 1 from deleted))
    BEGIN
		--删除
        INSERT UserLog_bak([username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate])
		SELECT [username]
			   ,[uid]
			   ,[enddate]
			   ,[startdate]
			   ,[createdate] FROM deleted
    END
END
GO

tracert -d www.baidu.com