SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2017 (RTM-CU21) (KB4557397) - 14.0.3335.7 (X64) 
	Jun 12 2020 20:39:00 
	Copyright (C) 2017 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table _Events
(
  ID int IDENTITY(1,1) NOT NULL,
  EventType int NOT NULL,
  EventName nvarchar(30) NOT NULL,
  EventCurrentGUID uniqueidentifier NOT NULL,
  CONSTRAINT Events_pk PRIMARY KEY CLUSTERED (ID ASC)
)
create index ixEventType on _Events (EventType)
insert into _Events (EventType, EventName, EventCurrentGUID) values (0, 'Complete', NEWID())
1 rows affected

select * from _Events;


ID
EventType
EventName
EventCurrentGUID


1
0
Complete
3dbf3321-48ed-4b8c-974e-d1a0d5e4a4ec


create trigger TR_Complete on _Events for insert, update, delete as
begin
  update _Events set EventCurrentGUID = NEWID() where EventType = 0;
end
insert into _Events (EventType, EventName, EventCurrentGUID) values (0, 'Completex', NEWID())
3 rows affected

select * from _Events;


ID
EventType
EventName
EventCurrentGUID


1
0
Complete
08c4c600-a6d2-4c34-be4f-529c0a430d0a

2
0
Completex
0b7b9ce4-2831-4116-b8f9-b14651352c1d

ID	EventType	EventName	EventCurrentGUID
1	0	Complete	08c4c600-a6d2-4c34-be4f-529c0a430d0a
2	0	Completex	0b7b9ce4-2831-4116-b8f9-b14651352c1d