PrepAway - Latest Free Exam Questions & Answers

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.

Key Words:

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,
SalesTerritoryID,
TotalDue
FROM Sales.OrdersByTerritory
WHERE SalesTerritoryID=@T
)


Leave a Reply