DELETE FROM [dbo].[Products] WHERE (([id_product] = @Original_id_product) AND ([product] = @Original_product) AND ([description] = @Original_description) AND ([price] = @Original_price) AND ([year_publishing] = @Original_year_publishing) AND ([id_country] = @Original_id_country) AND ([id_edition] = @Original_id_edition) AND ([id_genre] = @Original_id_genre) AND ([id_performer] = @Original_id_performer) AND ([id_supplier] = @Original_id_supplier)) INSERT INTO [dbo].[Products] ([product], [description], [price], [year_publishing], [id_country], [id_edition], [id_genre], [id_performer], [id_supplier]) VALUES (@product, @description, @price, @year_publishing, @id_country, @id_edition, @id_genre, @id_performer, @id_supplier); SELECT id_product, product, description, price, year_publishing, id_country, id_edition, id_genre, id_performer, id_supplier FROM Products WHERE (id_product = SCOPE_IDENTITY()) SELECT id_product, product, description, price, year_publishing, id_country, id_edition, id_genre, id_performer, id_supplier FROM dbo.Products UPDATE [dbo].[Products] SET [product] = @product, [description] = @description, [price] = @price, [year_publishing] = @year_publishing, [id_country] = @id_country, [id_edition] = @id_edition, [id_genre] = @id_genre, [id_performer] = @id_performer, [id_supplier] = @id_supplier WHERE (([id_product] = @Original_id_product) AND ([product] = @Original_product) AND ([description] = @Original_description) AND ([price] = @Original_price) AND ([year_publishing] = @Original_year_publishing) AND ([id_country] = @Original_id_country) AND ([id_edition] = @Original_id_edition) AND ([id_genre] = @Original_id_genre) AND ([id_performer] = @Original_id_performer) AND ([id_supplier] = @Original_id_supplier)); SELECT id_product, product, description, price, year_publishing, id_country, id_edition, id_genre, id_performer, id_supplier FROM Products WHERE (id_product = @id_product)