title: Table-Valued Parameters to CLR Procedures in SQL Server 2008 - possible?
body: <p><a href="http://msdn.microsoft.com/en-us/library/ms131094.aspx" rel="noreferrer">This page from SQL Server 2008 BOL</a>, talks about CLR Stored Procedures and has a section labelled, "Table-Valued Parameters", which talks about how they can be advantageous. That's great - I'd love to use TVPs in my CLR procs, but unfortunately this seems to be the only reference in the universe to such a possibility, and the section doesn't describe what the syntax would be (nor does the further information linked at the end of the paragraph)</p>
  
  <p>Sure, I can easily find descriptions of how to use TVPs from T-SQL procs, or how to do CLR procs in general. But writing a CLR proc that takes a TVP? Nothing. This is all highly unusal since the passing of multi-row data to a stored proc is a popular problem.</p>
  
  <p>This leads me to wonder if the presence of the section on that page is an error. Somebody please tell me it's not and point me to more info/ examples.</p>
  
  <p>[EDIT]</p>
  
  <p>I was about to post this to one of the MS forums too when I came across <a href="http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/58359996-2400-4e30-b82e-57f3abda9a37" rel="noreferrer">this, which seems to be the final nail in the coffin</a>. Looks like it can't be done.</p>