DELETE FROM [dbo].[DVDs] WHERE (([ID] = @Original_ID) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Actors = 1 AND [Actors] IS NULL) OR ([Actors] = @Original_Actors)) AND ((@IsNull_Director = 1 AND [Director] IS NULL) OR ([Director] = @Original_Director)) AND ((@IsNull_Genre = 1 AND [Genre] IS NULL) OR ([Genre] = @Original_Genre)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Rated = 1 AND [Rated] IS NULL) OR ([Rated] = @Original_Rated)) AND ((@IsNull_YearReleased = 1 AND [YearReleased] IS NULL) OR ([YearReleased] = @Original_YearReleased)) AND ((@IsNull_UPC = 1 AND [UPC] IS NULL) OR ([UPC] = @Original_UPC)) AND ((@IsNull_ImageLink = 1 AND [ImageLink] IS NULL) OR ([ImageLink] = @Original_ImageLink)) AND ((@IsNull_WebPageLink = 1 AND [WebPageLink] IS NULL) OR ([WebPageLink] = @Original_WebPageLink)) AND ((@IsNull_MyRating = 1 AND [MyRating] IS NULL) OR ([MyRating] = @Original_MyRating))) INSERT INTO [dbo].[DVDs] ([ID], [Title], [Description], [Actors], [Director], [Genre], [Length], [Rated], [YearReleased], [UPC], [ImageLink], [ImageBinary], [WebPageLink], [MyRating], [Comments]) VALUES (@ID, @Title, @Description, @Actors, @Director, @Genre, @Length, @Rated, @YearReleased, @UPC, @ImageLink, @ImageBinary, @WebPageLink, @MyRating, @Comments); SELECT ID, Title, Description, Actors, Director, Genre, Length, Rated, YearReleased, UPC, ImageLink, ImageBinary, WebPageLink, MyRating, Comments FROM DVDs WHERE (ID = @ID) SELECT ID, Title, Description, Actors, Director, Genre, Length, Rated, YearReleased, UPC, ImageLink, ImageBinary, WebPageLink, MyRating, Comments FROM dbo.DVDs UPDATE [dbo].[DVDs] SET [ID] = @ID, [Title] = @Title, [Description] = @Description, [Actors] = @Actors, [Director] = @Director, [Genre] = @Genre, [Length] = @Length, [Rated] = @Rated, [YearReleased] = @YearReleased, [UPC] = @UPC, [ImageLink] = @ImageLink, [ImageBinary] = @ImageBinary, [WebPageLink] = @WebPageLink, [MyRating] = @MyRating, [Comments] = @Comments WHERE (([ID] = @Original_ID) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Actors = 1 AND [Actors] IS NULL) OR ([Actors] = @Original_Actors)) AND ((@IsNull_Director = 1 AND [Director] IS NULL) OR ([Director] = @Original_Director)) AND ((@IsNull_Genre = 1 AND [Genre] IS NULL) OR ([Genre] = @Original_Genre)) AND ((@IsNull_Length = 1 AND [Length] IS NULL) OR ([Length] = @Original_Length)) AND ((@IsNull_Rated = 1 AND [Rated] IS NULL) OR ([Rated] = @Original_Rated)) AND ((@IsNull_YearReleased = 1 AND [YearReleased] IS NULL) OR ([YearReleased] = @Original_YearReleased)) AND ((@IsNull_UPC = 1 AND [UPC] IS NULL) OR ([UPC] = @Original_UPC)) AND ((@IsNull_ImageLink = 1 AND [ImageLink] IS NULL) OR ([ImageLink] = @Original_ImageLink)) AND ((@IsNull_WebPageLink = 1 AND [WebPageLink] IS NULL) OR ([WebPageLink] = @Original_WebPageLink)) AND ((@IsNull_MyRating = 1 AND [MyRating] IS NULL) OR ([MyRating] = @Original_MyRating))); SELECT ID, Title, Description, Actors, Director, Genre, Length, Rated, YearReleased, UPC, ImageLink, ImageBinary, WebPageLink, MyRating, Comments FROM DVDs WHERE (ID = @ID)