Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones The Basics of iTVFs RE: The Basics of iTVFs

  • January 10, 2019 at 11:40 am

    #2018603

    Steve Jones - SSC Editor - Thursday, January 10, 2019 9:46 AM

    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.

    Doesn't using a view essentially reuse the code in the view?  Or is the code reuse you're referring to rest in the fact that you don't have to re-specify the where clause logic you would normally need for using a view.