You develop a Microsoft SQL Server 2012 database.
You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?
A.
Inline user-defined function
B.
Stored procedure
C.
Table-valued user-defined function
D.
Scalar user-defined function
c
[…] A table-valued user-defined function can be used where table or view expressions are allowed in Transact-SQL queries. While views are limited to a single SELECT statement, user-defined functions can contain additional statements that allow more powerful logic than is possible in views.
A table-valued user-defined function can also replace stored procedures that return a single result set. The table returned by a user-defined function can be referenced in the FROM clause of a Transact-SQL statement, but >>stored procedures<< that return result sets cannot. […]
Source: https://technet.microsoft.com/en-us/library/ms191165%28v=sql.105%29.aspx
c
Why is it not In line user defined function?