Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones The Basics of iTVFs RE: The Basics of iTVFs
Steve Jones - SSC Editor
January 10, 2019 at 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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com