CLR Table-Valued Function Example with Full Streaming (STVF)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Solomon Rutzky » CLR Table-Valued Function Example with Full...

61 posts, Page 7 of 7

«««3 4 5 6 7

CLR Table-Valued Function Example with Full Streaming (STVF)

Rate Topic

Display Mode

Topic Options

Author

Message

algor 52977

Posted Tuesday, November 06, 2012 9:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 9:14 AM
Points: 1, Visits: 0

May be late to the game, but MSSQL 2008 R2 SP2 fix that.
the other option /works for me/:
My main function indeed had some arguments as SqlBytes XX1, XX2 ....
and by the end
foreach( var row in rows)
yield return row;
I was getting error, shown in the article, while
return rows was OK.\

Simple move of yield statement in separate function fixed it.
....
return InfoOut( row);
private static IEnumerable InfoOut( List<Row> rows)
{
foreach( var row in rows)
yield return row;
}

Post #1381630

« Prev Topic | Next Topic »

61 posts, Page 7 of 7

«««3 4 5 6 7

Permissions