I just published a new article titled “SQL Table Value parameters”. This article shows you how to use a TVP (which was a new feature of SQL 2008) from within SQL and also from a VB or C# application.
You can read it from http://www.emoreau.com/Entries/Articles/2010/11/SQL-Table-Value-parameters.aspx.