PrepAway - Latest Free Exam Questions & Answers

Which code segment should you use?

You have a view that was created by using the following code. You need to create an inline tablevalued function named Sales.fn_OrdersByTerritory, which must meet the following requirements:
– Accept the @T integer parameter.
– Use one-part names to reference columns.
– Filter the query results by SalesTerritoryID.
– Return the columns in the same order as the order used in
OrdersByTerritoryView.
Which code segment should you use? To answer, type the correct code in the answer area.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
CREATE FUNCTION Sales.fn_OrdersByTerritory (@T int)
RETURNS TABLE
AS
RETURN
(
SELECT OrderID,OrderDate,SalesTerrirotyID,TotalDue
FROM Sales.OrdersByTerritory
WHERE SalesTerritoryID = @T
)


Leave a Reply