I often stumble at the following while writing UDFs in SQL 2008. Please tell me whether my following assumptions are right or wrong.
- A UDF can return Data Table.
- But a UDF can't receive a Data Table as a parameter.
- A UDF can receive an User-Defined-Table- Type(UDTT) as a parameter.
- But a UDF can't return an User-Defined-Table-Type(UDTT).