You need to create an indexed view that requires logic statements to manipulate the data that the view displays.
Which two database objects should you use? Each correct answer presents a complete solution.
A.
a user-defined table-valued function
B.
a CRL function
C.
a stored procedure
D.
a user-defined scalar function
Explanation:
You can create a database object inside an instance of SQL Server that is programmed in an assembly created
in the Microsoft .NET Framework common language runtime (CLR). Database objects that can leverage the
rich programming model provided by the common language runtime include aggregate functions, functions,
stored procedures, triggers, and types.
i would say answer A and D , You cannot call a stored proc from inside a view
Agree. An inline table-valued function can perform as a parameterized view, but is still not allowed to call an SP like this.