You need to create an inline table-valued function name…

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. Sales.fn_OrdersByTerritory must meet the following requirements:
Use one-part names to reference columns.
Return the columns in the same order as the order used in OrdersByTerritoryView.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.

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. Sales.fn_OrdersByTerritory must meet the following requirements:
Use one-part names to reference columns.
Return the columns in the same order as the order used in OrdersByTerritoryView.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.

Answer: See the explanation

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

FROM Sales.OrdersByTerritory WHERE SalesTerritoryID=@T )

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Joe

Joe

Either the Question or the answer is wrong.

There is no condition for the SalesTerritory to be restricted.

For this question the answer has to be:

CREATE FUNCTION Sales.fn_OrdersByTerritory ()
RETURNS TABLE
AS
RETURN
(
SELECT OrderID, OrderDate, SalesTerritoryID, TotalDue
FROM Sales.OrdersByTerritory
)

Reply