Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««34567

CLR Table-Valued Function Example with Full Streaming (STVF) Expand / Collapse
Author
Message
Posted Tuesday, November 06, 2012 9:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase «««34567

Permissions Expand / Collapse