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.
精彩评论