SQL Server Trigger

USE [Fahrwerk]
GO
/****** Object:  Trigger [dbo].[Datum_Aenderung_Filiale]    Script Date: 11.04.2025 09:26:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Name
-- Create date:
-- Description:   
-- =============================================
ALTER TRIGGER [dbo].[Datum_Aenderung_Filiale]
   ON  [dbo].[BtoB_Filiale]
   AFTER INSERT,DELETE,UPDATE
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for trigger here
    Update BtoB_Filiale
    set BtoB_Filiale.Letzte_Aenderung =  GETDATE(),
    BtoB_Filiale.Aenderung_Durch=(SELECT login_name
        FROM sys.dm_exec_sessions
        where client_interface_name=N'ODBC'
        and host_name <> N'SQLServer'
        group by login_name)

END

USE [Fahrwerk]
GO
/****** Object:  Trigger [dbo].[Datum_Aenderung_Filiale]    Script Date: 11.04.2025 09:26:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Name
-- Create date: 
-- Description:    
-- =============================================
ALTER TRIGGER [dbo].[Datum_Aenderung_Filiale] 
   ON  [dbo].[BtoB_Filiale] 
   AFTER INSERT,UPDATE
AS 
BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    Declare @Index    int

    set @index = (SELECT idx_Filiale from inserted)

    -- Insert statements for trigger here
    Update BtoB_Filiale
    set BtoB_Filiale.Letzte_Aenderung =  GETDATE(),
    BtoB_Filiale.Aenderung_Durch=(SELECT login_name
        FROM sys.dm_exec_sessions
        where client_interface_name=N'ODBC'
        and host_name <> N'SQLServer'
        group by login_name)
    where BtoB_Filiale.idx_Filiale = @Index

END

USE [Fahrwerk]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[Datum_Aenderung_Filiale]
   ON  [dbo].[BtoB_Filiale]
   AFTER INSERT,UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO BtoB_Filiale(Letzte_Aenderung,Aenderung_Durch,fk_BtoB_Filiale,aktion)
    SELECT    getdate(),
            SYSTEM_USER,
            i.pk,
            (CASE WHEN i.pk IS NOT NULL AND d.pk IS NULL THEN 'Insert' WHEN i.pk IS NOT NULL AND d.pk IS NOT NULL THEN 'Update' WHEN i.pk IS NULL THEN 'Delete' ELSE NULL END)
    FROM    INSERTED i
    FULL OUTER JOIN DELETED d
    ON        i.pk = d.pk;

END

USE [Fahrwerk]
GO
/****** Object:  Trigger [dbo].[Datum_Aenderung_Filiale]    Script Date: 13.04.2025 08:21:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Name
-- Create date:
-- Description:   
-- =============================================
CREATE TRIGGER [dbo].[Datum_Aenderung_Filiale]
   ON  [dbo].[BtoB_Filiale]
   AFTER INSERT,UPDATE
AS
BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    Declare @Index    int

    set @index = (SELECT idx_Filiale from inserted)

    -- Insert statements for trigger here
    Update BtoB_Filiale
    set BtoB_Filiale.Letzte_Aenderung =  GETDATE(),
    BtoB_Filiale.Aenderung_Durch=(SELECT SYSTEM_USER)
    where BtoB_Filiale.idx_Filiale = @Index

END