create table Table1 (id int primary key, val int)
go
insert Table1 (id,val) select 1,1
go

-- Отреплицируется update
update Table1 set val=2 where id=1

-- Отреплицируется delete/insert
merge into Table1 as trg
using (select 1 as id, 2 as val) as src (id, val) on trg.id = src.id 
when matched and trg.val<>src.val then update set val = src.val;

create table dbo.Table1 (id int primary key, val int)
go
insert dbo.Table1 (id,val) select 1,1
go

begin tran Test1;
-- Отреплицируется update
update dbo.Table1 set val=2 where id=1

declare @tid varchar(30);
select @tid = [Transaction ID] from fn_dblog(null, null) where [Transaction Name] = 'Test1';
select [Current LSN], Operation, Context, AllocUnitName from fn_dblog(null, null) where [Transaction ID] = @tid;

rollback;
go

begin tran Test2;
-- Отреплицируется delete/insert
merge into dbo.Table1 as trg
using (select 1 as id, 2 as val) as src (id, val) on trg.id = src.id 
when matched and trg.val<>src.val then update set val = src.val;

declare @tid varchar(30);
select @tid = [Transaction ID] from fn_dblog(null, null) where [Transaction Name] = 'Test2';
select [Current LSN], Operation, Context, AllocUnitName from fn_dblog(null, null) where [Transaction ID] = @tid;

rollback;
go

drop table dbo.Table1;
go