Timeline for Use Stored Procedure or View to return Data from Multiple Tables
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 14, 2017 at 18:12 | comment | added | Jonathan Fite | If you can simplify your TVF query to the point where it qualifies as inline, you didn't really need a TVF to begin with. But you are correct that they perform better than multi-statement table valued functions. But the point of TVF is to allow for more complex logic than can be achieved in a single statement but without requiring the use of a stored procedure. | |
| Mar 14, 2017 at 18:04 | comment | added | SqlZim | Inline Table Valued Functions perform much better than multi-statement table valued functions. When is a SQL function not a function? "If it’s not inline, it’s rubbish." - Rob Farley | |
| Mar 14, 2017 at 17:43 | history | answered | Jonathan Fite | CC BY-SA 3.0 |