Which code segment should you use?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *