DELETE FROM [Production].[Product] WHERE (([ProductID] = @Original_ProductID) AND ([Name] = @Original_Name) AND ([ProductNumber] = @Original_ProductNumber) AND ([MakeFlag] = @Original_MakeFlag) AND ([FinishedGoodsFlag] = @Original_FinishedGoodsFlag) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ([SafetyStockLevel] = @Original_SafetyStockLevel) AND ([ReorderPoint] = @Original_ReorderPoint) AND ([StandardCost] = @Original_StandardCost) AND ([ListPrice] = @Original_ListPrice) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size)) AND ((@IsNull_SizeUnitMeasureCode = 1 AND [SizeUnitMeasureCode] IS NULL) OR ([SizeUnitMeasureCode] = @Original_SizeUnitMeasureCode)) AND ((@IsNull_WeightUnitMeasureCode = 1 AND [WeightUnitMeasureCode] IS NULL) OR ([WeightUnitMeasureCode] = @Original_WeightUnitMeasureCode)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ([DaysToManufacture] = @Original_DaysToManufacture) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ((@IsNull_Style = 1 AND [Style] IS NULL) OR ([Style] = @Original_Style)) AND ((@IsNull_ProductSubcategoryID = 1 AND [ProductSubcategoryID] IS NULL) OR ([ProductSubcategoryID] = @Original_ProductSubcategoryID)) AND ((@IsNull_ProductModelID = 1 AND [ProductModelID] IS NULL) OR ([ProductModelID] = @Original_ProductModelID)) AND ([SellStartDate] = @Original_SellStartDate) AND ((@IsNull_SellEndDate = 1 AND [SellEndDate] IS NULL) OR ([SellEndDate] = @Original_SellEndDate)) AND ((@IsNull_DiscontinuedDate = 1 AND [DiscontinuedDate] IS NULL) OR ([DiscontinuedDate] = @Original_DiscontinuedDate)) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate)) INSERT INTO [Production].[Product] ([Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES (@Name, @ProductNumber, @MakeFlag, @FinishedGoodsFlag, @Color, @SafetyStockLevel, @ReorderPoint, @StandardCost, @ListPrice, @Size, @SizeUnitMeasureCode, @WeightUnitMeasureCode, @Weight, @DaysToManufacture, @ProductLine, @Class, @Style, @ProductSubcategoryID, @ProductModelID, @SellStartDate, @SellEndDate, @DiscontinuedDate, @rowguid, @ModifiedDate); SELECT ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, ProductModelID, SellStartDate, SellEndDate, DiscontinuedDate, rowguid, ModifiedDate FROM Production.Product WHERE (ProductID = SCOPE_IDENTITY()) SELECT ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, ProductModelID, SellStartDate, SellEndDate, DiscontinuedDate, rowguid, ModifiedDate FROM Production.Product UPDATE [Production].[Product] SET [Name] = @Name, [ProductNumber] = @ProductNumber, [MakeFlag] = @MakeFlag, [FinishedGoodsFlag] = @FinishedGoodsFlag, [Color] = @Color, [SafetyStockLevel] = @SafetyStockLevel, [ReorderPoint] = @ReorderPoint, [StandardCost] = @StandardCost, [ListPrice] = @ListPrice, [Size] = @Size, [SizeUnitMeasureCode] = @SizeUnitMeasureCode, [WeightUnitMeasureCode] = @WeightUnitMeasureCode, [Weight] = @Weight, [DaysToManufacture] = @DaysToManufacture, [ProductLine] = @ProductLine, [Class] = @Class, [Style] = @Style, [ProductSubcategoryID] = @ProductSubcategoryID, [ProductModelID] = @ProductModelID, [SellStartDate] = @SellStartDate, [SellEndDate] = @SellEndDate, [DiscontinuedDate] = @DiscontinuedDate, [rowguid] = @rowguid, [ModifiedDate] = @ModifiedDate WHERE (([ProductID] = @Original_ProductID) AND ([Name] = @Original_Name) AND ([ProductNumber] = @Original_ProductNumber) AND ([MakeFlag] = @Original_MakeFlag) AND ([FinishedGoodsFlag] = @Original_FinishedGoodsFlag) AND ((@IsNull_Color = 1 AND [Color] IS NULL) OR ([Color] = @Original_Color)) AND ([SafetyStockLevel] = @Original_SafetyStockLevel) AND ([ReorderPoint] = @Original_ReorderPoint) AND ([StandardCost] = @Original_StandardCost) AND ([ListPrice] = @Original_ListPrice) AND ((@IsNull_Size = 1 AND [Size] IS NULL) OR ([Size] = @Original_Size)) AND ((@IsNull_SizeUnitMeasureCode = 1 AND [SizeUnitMeasureCode] IS NULL) OR ([SizeUnitMeasureCode] = @Original_SizeUnitMeasureCode)) AND ((@IsNull_WeightUnitMeasureCode = 1 AND [WeightUnitMeasureCode] IS NULL) OR ([WeightUnitMeasureCode] = @Original_WeightUnitMeasureCode)) AND ((@IsNull_Weight = 1 AND [Weight] IS NULL) OR ([Weight] = @Original_Weight)) AND ([DaysToManufacture] = @Original_DaysToManufacture) AND ((@IsNull_ProductLine = 1 AND [ProductLine] IS NULL) OR ([ProductLine] = @Original_ProductLine)) AND ((@IsNull_Class = 1 AND [Class] IS NULL) OR ([Class] = @Original_Class)) AND ((@IsNull_Style = 1 AND [Style] IS NULL) OR ([Style] = @Original_Style)) AND ((@IsNull_ProductSubcategoryID = 1 AND [ProductSubcategoryID] IS NULL) OR ([ProductSubcategoryID] = @Original_ProductSubcategoryID)) AND ((@IsNull_ProductModelID = 1 AND [ProductModelID] IS NULL) OR ([ProductModelID] = @Original_ProductModelID)) AND ([SellStartDate] = @Original_SellStartDate) AND ((@IsNull_SellEndDate = 1 AND [SellEndDate] IS NULL) OR ([SellEndDate] = @Original_SellEndDate)) AND ((@IsNull_DiscontinuedDate = 1 AND [DiscontinuedDate] IS NULL) OR ([DiscontinuedDate] = @Original_DiscontinuedDate)) AND ([rowguid] = @Original_rowguid) AND ([ModifiedDate] = @Original_ModifiedDate)); SELECT ProductID, Name, ProductNumber, MakeFlag, FinishedGoodsFlag, Color, SafetyStockLevel, ReorderPoint, StandardCost, ListPrice, Size, SizeUnitMeasureCode, WeightUnitMeasureCode, Weight, DaysToManufacture, ProductLine, Class, Style, ProductSubcategoryID, ProductModelID, SellStartDate, SellEndDate, DiscontinuedDate, rowguid, ModifiedDate FROM Production.Product WHERE (ProductID = @ProductID) DELETE FROM [Purchasing].[PurchaseOrderDetail] WHERE (([PurchaseOrderID] = @Original_PurchaseOrderID) AND ([PurchaseOrderDetailID] = @Original_PurchaseOrderDetailID) AND ([DueDate] = @Original_DueDate) AND ([OrderQty] = @Original_OrderQty) AND ([ProductID] = @Original_ProductID) AND ([UnitPrice] = @Original_UnitPrice) AND ([LineTotal] = @Original_LineTotal) AND ([ReceivedQty] = @Original_ReceivedQty) AND ([RejectedQty] = @Original_RejectedQty) AND ([StockedQty] = @Original_StockedQty) AND ([ModifiedDate] = @Original_ModifiedDate)) INSERT INTO [Purchasing].[PurchaseOrderDetail] ([PurchaseOrderID], [DueDate], [OrderQty], [ProductID], [UnitPrice], [LineTotal], [ReceivedQty], [RejectedQty], [StockedQty], [ModifiedDate]) VALUES (@PurchaseOrderID, @DueDate, @OrderQty, @ProductID, @UnitPrice, @LineTotal, @ReceivedQty, @RejectedQty, @StockedQty, @ModifiedDate); SELECT PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate FROM Purchasing.PurchaseOrderDetail WHERE (PurchaseOrderDetailID = SCOPE_IDENTITY()) AND (PurchaseOrderID = @PurchaseOrderID) SELECT PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate FROM Purchasing.PurchaseOrderDetail UPDATE [Purchasing].[PurchaseOrderDetail] SET [PurchaseOrderID] = @PurchaseOrderID, [DueDate] = @DueDate, [OrderQty] = @OrderQty, [ProductID] = @ProductID, [UnitPrice] = @UnitPrice, [LineTotal] = @LineTotal, [ReceivedQty] = @ReceivedQty, [RejectedQty] = @RejectedQty, [StockedQty] = @StockedQty, [ModifiedDate] = @ModifiedDate WHERE (([PurchaseOrderID] = @Original_PurchaseOrderID) AND ([PurchaseOrderDetailID] = @Original_PurchaseOrderDetailID) AND ([DueDate] = @Original_DueDate) AND ([OrderQty] = @Original_OrderQty) AND ([ProductID] = @Original_ProductID) AND ([UnitPrice] = @Original_UnitPrice) AND ([LineTotal] = @Original_LineTotal) AND ([ReceivedQty] = @Original_ReceivedQty) AND ([RejectedQty] = @Original_RejectedQty) AND ([StockedQty] = @Original_StockedQty) AND ([ModifiedDate] = @Original_ModifiedDate)); SELECT PurchaseOrderID, PurchaseOrderDetailID, DueDate, OrderQty, ProductID, UnitPrice, LineTotal, ReceivedQty, RejectedQty, StockedQty, ModifiedDate FROM Purchasing.PurchaseOrderDetail WHERE (PurchaseOrderDetailID = @PurchaseOrderDetailID) AND (PurchaseOrderID = @PurchaseOrderID)