DELETE FROM [dbo].[Product] WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock)) INSERT INTO [dbo].[Product] ([ProductArticleNumber], [ProductName], [ProductDescription], [ProductCategory], [ProductPhoto], [ProductManufacturer], [ProductCost], [ProductDiscountAmount], [ProductQuantityInStock]) VALUES (@ProductArticleNumber, @ProductName, @ProductDescription, @ProductCategory, @ProductPhoto, @ProductManufacturer, @ProductCost, @ProductDiscountAmount, @ProductQuantityInStock); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber) SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock FROM dbo.Product UPDATE [dbo].[Product] SET [ProductArticleNumber] = @ProductArticleNumber, [ProductName] = @ProductName, [ProductDescription] = @ProductDescription, [ProductCategory] = @ProductCategory, [ProductPhoto] = @ProductPhoto, [ProductManufacturer] = @ProductManufacturer, [ProductCost] = @ProductCost, [ProductDiscountAmount] = @ProductDiscountAmount, [ProductQuantityInStock] = @ProductQuantityInStock WHERE (([ProductArticleNumber] = @Original_ProductArticleNumber) AND ([ProductCost] = @Original_ProductCost) AND ((@IsNull_ProductDiscountAmount = 1 AND [ProductDiscountAmount] IS NULL) OR ([ProductDiscountAmount] = @Original_ProductDiscountAmount)) AND ([ProductQuantityInStock] = @Original_ProductQuantityInStock)); SELECT ProductArticleNumber, ProductName, ProductDescription, ProductCategory, ProductPhoto, ProductManufacturer, ProductCost, ProductDiscountAmount, ProductQuantityInStock FROM Product WHERE (ProductArticleNumber = @ProductArticleNumber)