Trigger: Create trigger with all CRUD ( insert, update ,delete )

 alter trigger SynchTriggerForTestDataFactoryLog

on dbo.TestDataFactoryLogOnPremise

after update,insert,delete 

as 

begin

if(ROWCOUNT_BIG() = 0)

return;

declare @activity varchar(20);

if exists(SELECT * from inserted) and exists (SELECT * from deleted)

begin

    SET @activity = 'UPDATE'

    insert into TestSyncOcrLog select 'TestDataFactoryLogOnPremise' as SourceName,Id as SourceID,0 as IsSyncForOnPrmise,1 as IsSyncForCloud,@activity as Activity

from inserted

end

If exists (Select * from inserted) and not exists(Select * from deleted)

begin

   SET @activity = 'INSERT';

   insert into TestSyncOcrLog select 'TestDataFactoryLogOnPremise' as SourceName,Id as SourceID,0 as IsSyncForOnPrmise,1 as IsSyncForCloud,@activity as Activity

from inserted

end

If exists(select * from deleted) and not exists(Select * from inserted)

begin 

   SET @activity = 'DELETE';

  insert into TestSyncOcrLog select 'TestDataFactoryLogOnPremise' as SourceName,Id as SourceID,0 as IsSyncForOnPrmise,1 as IsSyncForCloud,@activity as Activity

from deleted

end

end