You have a table named Product.
You need to increase product prices for only the vendor named Coho Winery by 10 percent and then return a list of the products and updated prices.
Which code segment should you use?
A.
UPDATE Product SET Price = Price * 1.10, ProductName = ProductName
WHERE Product.VendorName = ‘Coho Winery’
B.
UPDATE Product SET Price = Price * 1.10 OUTPUT inserted.ProductName, deleted.Price WHERE Product.VendorName = ‘Coho Winery’
C.
UPDATE Product SET Price = Price * 1.10 OUTPUT inserted.ProductName, inserted.Price WHERE Product.VendorName = ‘Coho Winery’
D.
UPDATE Product SET Price = Price * 1.10, VendorName = ‘Coho Winery’
OUTPUT inserted.ProductName, inserted.Price