Câu 21: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

You develop a Microsoft SQL Server database that contains a table named Products. The Products table has columns named ProductId, CategoryId, Name, andPrice. Product prices are often updated as follows: ✑ For a single product by a specific value by using the ProductId column ✑ For an entire category by a percentage by using the CategoryId columnYou need to log the change price to a new table named PriceChange by using the ProductId' ChangedValue, and ChangedDate columns. You also need to ensure that increases in price are recorded as positive values and decreases in price as negative values. Which Transact-SQL query should you use?

1. A. Lựa chọn A bằng hình ảnh
2. B. Lựa chọn B bằng hình ảnh
3. C. Lựa chọn C bằng hình ảnh
4. D. Lựa chọn D bằng hình ảnh — đáp án hiện tại