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.

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 )

2 Comments on “You need to create an inline table-valued function name…”

  1. Joe says:

    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
    )




    15



    0

Leave a Reply