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.