Update:
Ich hab jetzt meine erste Originaltabelle umgesetzt, das Script sieht analog dazu so aus:
CREATE TRIGGER [dbo].[Tab_01_insert]
ON [DB_TEST].[dbo].[Tab_01]
INSTEAD OF INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [DB_TEST].[dbo].[Tab_01](PK,NULL,Col_02,NULL,Col_04,Col_05,Col_nn)
SELECT i.PK,NULL,i.Col_02,NULL,i.Col_04,i.Col_05,i.Col_nn
FROM INSERTED i
LEFT JOIN DELETED d
ON i.pk = d.pk
WHERE d.pk IS NULL
ON i.Col_01 = d.Col_01
WHERE d.Col_01 IS NULL
ON i.Col_02 = d.Col_02
WHERE d.Col_02 IS NULL
ON i.Col_03 = d.Col_03
WHERE d.Col_03 IS NULL
ON i.Col_04 = d.Col_04
WHERE d.Col_04 IS NULL
ON i.Col_05 = d.Col_05
WHERE d.Col_05 IS NULL
ON i.Col_nn = d.Col_nn
WHERE d.Col_nn IS NULL
UPDATE [DB_TEST].[dbo].[Tab_01]
SET [DB_TEST].[dbo].[Tab_01].pk = i.pk,
[DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
[DB_TEST].[dbo].[Tab_01].Col_02 = i.Col_02,
[DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
[DB_TEST].[dbo].[Tab_01].Col_04 = i.Col_04,
[DB_TEST].[dbo].[Tab_01].Col_05 = i.Col_05,
[DB_TEST].[dbo].[Tab_01].Col_nn = i.Col_nn,
FROM [DB_TEST].[dbo].[Tab_01]
INNER JOIN INSERTED i
ON [DB_TEST].[dbo].[Tab_01].pk = i.pk,
ON [DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
ON [DB_TEST].[dbo].[Tab_01].Col_02 = i.Col_02,
ON [DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
ON [DB_TEST].[dbo].[Tab_01].Col_04 = i.Col_04,
ON [DB_TEST].[dbo].[Tab_01].Col_05 = i.Col_05,
ON [DB_TEST].[dbo].[Tab_01].Col_nn = i.Col_nn,
FROM [DB_TEST].[dbo].[Tab_01]
INNER JOIN DELETED d
ON [DB_TEST].[dbo].[Tab_01].pk = i.pk,
ON [DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
ON [DB_TEST].[dbo].[Tab_01].Col_02 = i.Col_02,
ON [DB_TEST].[dbo].[Tab_01].Col_01 = NULL,
ON [DB_TEST].[dbo].[Tab_01].Col_04 = i.Col_04,
ON [DB_TEST].[dbo].[Tab_01].Col_05 = i.Col_05,
ON [DB_TEST].[dbo].[Tab_01].Col_nn = i.Col_nn,
END
GO
Ist das so vom Aufbau her richtig oder doch irgendwas falsch verstanden/völlig schräg?
