HOTSPOT
-
You have a Fabric warehouse that contains a table named Table1. Table1 contains the following data.
You need to create a T-SQL statement that meets the following requirements:
• Outputs the item name of each item and returns a null value if the item name is longer than 20 characters
• Outputs the PurchaseDate value in the format of МММ dd, yy
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Azure_2023
4 days, 20 hours ago