DELETE FROM [dbo].[Ort] WHERE (([Id_Ort] = @Original_Id_Ort) AND ((@IsNull_Ort = 1 AND [Ort] IS NULL) OR ([Ort] = @Original_Ort)) AND ((@IsNull_PLZ = 1 AND [PLZ] IS NULL) OR ([PLZ] = @Original_PLZ))) INSERT INTO [dbo].[Ort] ([Id_Ort], [Ort], [PLZ]) VALUES (@Id_Ort, @Ort, @PLZ); SELECT Id_Ort, Ort, PLZ FROM Ort WHERE (Id_Ort = @Id_Ort) SELECT Id_Ort, Ort, PLZ FROM dbo.Ort UPDATE [dbo].[Ort] SET [Id_Ort] = @Id_Ort, [Ort] = @Ort, [PLZ] = @PLZ WHERE (([Id_Ort] = @Original_Id_Ort) AND ((@IsNull_Ort = 1 AND [Ort] IS NULL) OR ([Ort] = @Original_Ort)) AND ((@IsNull_PLZ = 1 AND [PLZ] IS NULL) OR ([PLZ] = @Original_PLZ))); SELECT Id_Ort, Ort, PLZ FROM Ort WHERE (Id_Ort = @Id_Ort) DELETE FROM [dbo].[Srtasse] WHERE (([Id_Strasse] = @Original_Id_Strasse) AND ((@IsNull_Strasse = 1 AND [Strasse] IS NULL) OR ([Strasse] = @Original_Strasse))) INSERT INTO [dbo].[Srtasse] ([Id_Strasse], [Strasse]) VALUES (@Id_Strasse, @Strasse); SELECT Id_Strasse, Strasse FROM Srtasse WHERE (Id_Strasse = @Id_Strasse) SELECT Id_Strasse, Strasse FROM dbo.Srtasse UPDATE [dbo].[Srtasse] SET [Id_Strasse] = @Id_Strasse, [Strasse] = @Strasse WHERE (([Id_Strasse] = @Original_Id_Strasse) AND ((@IsNull_Strasse = 1 AND [Strasse] IS NULL) OR ([Strasse] = @Original_Strasse))); SELECT Id_Strasse, Strasse FROM Srtasse WHERE (Id_Strasse = @Id_Strasse) INSERT INTO [dbo].[Waren] ([Id_Ware], [Ware], [Preis]) VALUES (@Id_Ware, @Ware, @Preis) SELECT Id_Ware, Ware, Preis FROM dbo.Waren DELETE FROM [dbo].[Bezahlung] WHERE (([Id_Rechnung] = @Original_Id_Rechnung) AND ((@IsNull_Id_Daten = 1 AND [Id_Daten] IS NULL) OR ([Id_Daten] = @Original_Id_Daten)) AND ((@IsNull_Id_Waren = 1 AND [Id_Waren] IS NULL) OR ([Id_Waren] = @Original_Id_Waren)) AND ((@IsNull_Bezahlung = 1 AND [Bezahlung] IS NULL) OR ([Bezahlung] = @Original_Bezahlung))) INSERT INTO [dbo].[Bezahlung] ([Id_Rechnung], [Id_Daten], [Id_Waren], [Bezahlung]) VALUES (@Id_Rechnung, @Id_Daten, @Id_Waren, @Bezahlung); SELECT Id_Rechnung, Id_Daten, Id_Waren, Bezahlung FROM Bezahlung WHERE (Id_Rechnung = @Id_Rechnung) SELECT Id_Rechnung, Id_Daten, Id_Waren, Bezahlung FROM dbo.Bezahlung UPDATE [dbo].[Bezahlung] SET [Id_Rechnung] = @Id_Rechnung, [Id_Daten] = @Id_Daten, [Id_Waren] = @Id_Waren, [Bezahlung] = @Bezahlung WHERE (([Id_Rechnung] = @Original_Id_Rechnung) AND ((@IsNull_Id_Daten = 1 AND [Id_Daten] IS NULL) OR ([Id_Daten] = @Original_Id_Daten)) AND ((@IsNull_Id_Waren = 1 AND [Id_Waren] IS NULL) OR ([Id_Waren] = @Original_Id_Waren)) AND ((@IsNull_Bezahlung = 1 AND [Bezahlung] IS NULL) OR ([Bezahlung] = @Original_Bezahlung))); SELECT Id_Rechnung, Id_Daten, Id_Waren, Bezahlung FROM Bezahlung WHERE (Id_Rechnung = @Id_Rechnung) DELETE FROM [dbo].[PersonalDaten] WHERE (([Id_Num] = @Original_Id_Num) AND ((@IsNull_Anrede = 1 AND [Anrede] IS NULL) OR ([Anrede] = @Original_Anrede)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Vorname = 1 AND [Vorname] IS NULL) OR ([Vorname] = @Original_Vorname)) AND ((@IsNull_GeburtsDatum = 1 AND [GeburtsDatum] IS NULL) OR ([GeburtsDatum] = @Original_GeburtsDatum)) AND ((@IsNull_Id_Ort = 1 AND [Id_Ort] IS NULL) OR ([Id_Ort] = @Original_Id_Ort)) AND ((@IsNull_Id_strasse = 1 AND [Id_strasse] IS NULL) OR ([Id_strasse] = @Original_Id_strasse)) AND ((@IsNull_Haus = 1 AND [Haus] IS NULL) OR ([Haus] = @Original_Haus))) INSERT INTO [dbo].[PersonalDaten] ([Id_Num], [Anrede], [Name], [Vorname], [GeburtsDatum], [Id_Ort], [Id_strasse], [Haus]) VALUES (@Id_Num, @Anrede, @Name, @Vorname, @GeburtsDatum, @Id_Ort, @Id_strasse, @Haus); SELECT Id_Num, Anrede, Name, Vorname, GeburtsDatum, Id_Ort, Id_strasse, Haus FROM PersonalDaten WHERE (Id_Num = @Id_Num) SELECT Id_Num, Anrede, Name, Vorname, GeburtsDatum, Id_Ort, Id_strasse, Haus FROM dbo.PersonalDaten UPDATE [dbo].[PersonalDaten] SET [Id_Num] = @Id_Num, [Anrede] = @Anrede, [Name] = @Name, [Vorname] = @Vorname, [GeburtsDatum] = @GeburtsDatum, [Id_Ort] = @Id_Ort, [Id_strasse] = @Id_strasse, [Haus] = @Haus WHERE (([Id_Num] = @Original_Id_Num) AND ((@IsNull_Anrede = 1 AND [Anrede] IS NULL) OR ([Anrede] = @Original_Anrede)) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Vorname = 1 AND [Vorname] IS NULL) OR ([Vorname] = @Original_Vorname)) AND ((@IsNull_GeburtsDatum = 1 AND [GeburtsDatum] IS NULL) OR ([GeburtsDatum] = @Original_GeburtsDatum)) AND ((@IsNull_Id_Ort = 1 AND [Id_Ort] IS NULL) OR ([Id_Ort] = @Original_Id_Ort)) AND ((@IsNull_Id_strasse = 1 AND [Id_strasse] IS NULL) OR ([Id_strasse] = @Original_Id_strasse)) AND ((@IsNull_Haus = 1 AND [Haus] IS NULL) OR ([Haus] = @Original_Haus))); SELECT Id_Num, Anrede, Name, Vorname, GeburtsDatum, Id_Ort, Id_strasse, Haus FROM PersonalDaten WHERE (Id_Num = @Id_Num)