A little intro

The Table Valued Parameters were introduced in SQL Server 2008 as a solution to allow multiple rows of structured data to be passed as parameters to stored procedures. For a brief introduction to this subject please refer to this article.

This feature immediately caught my attention but I’ve avoided it’s usage because I didn’t like the fact that on the examples I saw there was always the need to convert your in memory data structure to a DataTable which is in my opinion such a heavy class to instantiate just to pass a parameter, so I continued using comma separated lists of identifiers or XML for more complex data.

...