You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five products are priced at $10 per unit and have PriceIncrease set to 0. You have the following query:

INSERT dbo.PriceChange (ProductID, Change, ChangeDate) SELECT ProductID, inPrice -delPrice, SYSDATETIME() FROM ( UPDATE dbo.Products SET Price *= 1.1 OUTPUT inserted.ProductID, inserted.Price, deleted.Price WHERE PriceIncrease = 1 ) p (ProductID, inPrice, delPrice); You need to predict the results of the query. Which results should the query produce?

Question

You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five products are priced at $10 per unit and have PriceIncrease set to 0. You have the following query:

INSERT dbo.PriceChange (ProductID, Change, ChangeDate) SELECT ProductID, inPrice -delPrice, SYSDATETIME() FROM ( UPDATE dbo.Products SET Price *= 1.1 OUTPUT inserted.ProductID, inserted.Price, deleted.Price WHERE PriceIncrease = 1 ) p (ProductID, inPrice, delPrice); You need to predict the results of the query. Which results should the query produce?

Accepted Answer

A. Five rows are updated in dbo.Products.

Answer

B. Five rows are updated in dbo.Products.

Answer

C. No rows are updated in dbo.Products.

Answer

D. No rows are updated in dbo.Products.

You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five…

Question

Options

How the community answered

Community Discussion