1. What is the difference in the choice of information from the set of columns, not counting the fact that in the Multi-Statement Table Valued Function you can write some logic. Suppose if you just need to pull data from several tables? When to use:

    1) Table-valued Function ?
    2) Multi-Statement Table Valued Function ?
    3) View`?

  2. Suppose the Multi-Statement Table Valued Function used when some kind of logic is needed. Then the question is

    1) Table-valued Function ?
    2) View ?

    1 answer 1

    I think I figured out the Table-valued Function vs View vs Multi-Statement Table Valued Function