Function to return a cursor(result set)

Is it possible to return a cursor from开发者_JS百科 a user defined function in MS SQL Server2005? If it is, how is that done?

---

Based on the result returned, user-defined functions in SQL Server can be either scalar or table-valued. The former return single values of simple types: int, datetime etc., and the latter return row sets.

There are no cursor-valued functions in SQL Server.