Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Solomon Rutzky CLR Table-Valued Function Example with Full Streaming (STVF) RE: CLR Table-Valued Function Example with Full Streaming (STVF)

  • September 10, 2010 at 6:03 am

    #1219106

    Matjaz Justin (9/10/2010)

    My question is: is it possible to have CLR table-valued function with variable number of return columns?

    All functions (T-SQL or SQLCLR) must return a deterministic set of columns. The same requirement does not apply to stored procedures, so a SQLCLR stored procedure is a better bet if you truly need this functionality.

    If you would like a more detailed reply from more than one person, please repost your question in the CLR forums on this site.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi