Which code segment should you use?

CORRECT TEXT

You have a view that was created by using the following code:

You need to create an inline table-valued 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.

View Answer

Answer: CREATE FUNCTION Sales.fn_OrdersByTerritory (@T int)

RETURNS TABLE

AS

RETURN

(

SELECT OrderID,OrderDate,SalesTerrirotyID,TotalDue

FROM Sales.OrdersByTerritory

WHERE SalesTerritoryID = @T

)