Hi Friends, I was wondering when should I use table valued functions. And when are they most convenient to use. Thanks !

I use a table function when I need to pass in a parameter against the WHERE clause to return a different recordset. Here is a good example: [image] SQL Server Table-Valued Function By Practical Examples This tutorial introduces you to SQL Server table-valued function including inline tab…

Table Valued Function

Transact-SQL

BabyAqua October 18, 2019, 9:40pm 2

I use a table function when I need to pass in a parameter against the WHERE clause to return a different recordset.

Here is a good example:

1 Like