Table Valued Function

Transact-SQL
1

Hi Friends,

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

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