We walk in the dark places no others will enter
We stand on the bridge and no one may pass

IF OBJECT_ID('tr_view_badge') IS NOT NULL
	DROP TRIGGER tr_view_badge
go
create trigger tr_view_badge
	on view_badge
	instead of insert, update, delete
as
BEGIN
	DECLARE @action CHAR(1)
	IF(EXISTS(SELECT * FROM inserted) AND EXISTS(SELECT * FROM deleted))
		SET @action = 'U'
	ELSE IF(EXISTS(SELECT * FROM inserted))
		SET @action = 'I'
	ELSE IF(EXISTS(SELECT * FROM deleted))
		SET @action = 'D'

	IF @action IS NULL
		return

	--Do what you need to the table based on the action

END
GO