Set isolation level snapshot

CREATE OR RAPLACE TRIGGER T_U_LOG AFTER UPDATE ON T FOR EACH ROW
BEGIN
  INSERT INTO LOG_TABLE (OP, OLD_PK, NEW_PK)
   VALUES ('U', TO_CHAR(:OLD.PK), TO_CHAR(:NEW.PK));
END;

 CREATE TRIGGER T_U_LOG ON T AFTER UPDATE
AS
BEGIN
  INSERT INTO LOG_TABLE (OP, OLD_PK, NEW_PK)
   VALUES ('U', (SELECT CONVERT(CHAR( 10 ), PK) FROM DELETED), (SELECT CONVERT(CHAR( 10 ), PK) FROM INSERTED));
END;

 CREATE TRIGGER T_U_LOG ON T AFTER UPDATE
AS
BEGIN
  INSERT INTO LOG_TABLE (OP, OLD_PK, NEW_PK)
   VALUES ('U', (SELECT CONVERT(CHAR( 10 ), PK) FROM DELETED), (SELECT CONVERT(CHAR( 10 ), PK) FROM INSERTED));
END;

CREATE TRIGGER T_U_LOG ON T AFTER UPDATE
AS
BEGIN
select pk  into #t1 from inserted
select pk into #t2 from deleted
alter table #t1
add num int identity( 1 , 1 )
alter table #t2
add num int identity( 1 , 1 )
select #t1.pk as new_pk, #t2.pk as old_pk  into #t3 from #t1 join #t2 on #t1.num=#t2.num 
INSERT INTO LOG_TABLE (OP, OLD_PK, NEW_PK)
VALUES ('U', (SELECT CONVERT(CHAR( 10 ), OLD_PK) FROM #t3), (SELECT CONVERT(CHAR( 10 ), NEW_PK) FROM #t3))
drop table #t1
drop table #t2
drop table #t3
END