• Steve Jones - SSC Editor

    SSC Guru

    Points: 714078

    Derek-905092 - Thursday, January 10, 2019 5:16 AM

    So it looks to me like an iTVF without a parameter is essentially the same as a view. What criteria would you use to decide whether to use an iTVF or a view?

    iTVFs allow you to parameterize them, which a view doesn't. You can certainly add a WHERE clause, but that doesn't allow reusing of the code in the same way.