DELETE FROM [CloudsTable] WHERE (([CloudID] = @Original_CloudID) AND ((@IsNull_TypeID = 1 AND [TypeID] IS NULL) OR ([TypeID] = @Original_TypeID)) AND ((@IsNull_DateID = 1 AND [DateID] IS NULL) OR ([DateID] = @Original_DateID)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Height = 1 AND [Height] IS NULL) OR ([Height] = @Original_Height))) INSERT INTO [CloudsTable] ([CloudID], [TypeID], [DateID], [Width], [Height], [Image]) VALUES (@CloudID, @TypeID, @DateID, @Width, @Height, @Image); SELECT CloudID, TypeID, DateID, Width, Height, Image FROM CloudsTable WHERE (CloudID = @CloudID) SELECT CloudID, TypeID, DateID, Width, Height, Image FROM CloudsTable UPDATE [CloudsTable] SET [CloudID] = @CloudID, [TypeID] = @TypeID, [DateID] = @DateID, [Width] = @Width, [Height] = @Height, [Image] = @Image WHERE (([CloudID] = @Original_CloudID) AND ((@IsNull_TypeID = 1 AND [TypeID] IS NULL) OR ([TypeID] = @Original_TypeID)) AND ((@IsNull_DateID = 1 AND [DateID] IS NULL) OR ([DateID] = @Original_DateID)) AND ((@IsNull_Width = 1 AND [Width] IS NULL) OR ([Width] = @Original_Width)) AND ((@IsNull_Height = 1 AND [Height] IS NULL) OR ([Height] = @Original_Height))); SELECT CloudID, TypeID, DateID, Width, Height, Image FROM CloudsTable WHERE (CloudID = @CloudID) DELETE FROM [dbo].[Date] WHERE (([DateID] = @Original_DateID)) INSERT INTO [dbo].[Date] ([DateID], [Date]) VALUES (@DateID, @Date); SELECT DateID, Date FROM Date WHERE (DateID = @DateID) SELECT DateID, Date FROM dbo.Date UPDATE [dbo].[Date] SET [DateID] = @DateID, [Date] = @Date WHERE (([DateID] = @Original_DateID)); SELECT DateID, Date FROM Date WHERE (DateID = @DateID) DELETE FROM [dbo].[Types] WHERE (([TypeID] = @Original_TypeID)) INSERT INTO [dbo].[Types] ([TypeID], [Name], [Comment]) VALUES (@TypeID, @Name, @Comment); SELECT TypeID, Name, Comment FROM Types WHERE (TypeID = @TypeID) SELECT TypeID, Name, Comment FROM dbo.Types UPDATE [dbo].[Types] SET [TypeID] = @TypeID, [Name] = @Name, [Comment] = @Comment WHERE (([TypeID] = @Original_TypeID)); SELECT TypeID, Name, Comment FROM Types WHERE (TypeID = @TypeID)