SQL Server’s Table-Valued Parameters are useful, and easy to use, but you should be aware that something that looks loke a table, and seems to behave like a table, can’t necessarily be used just like any other table. Leidago gives a developer’s guide on how, and why, you should use TVPs in your application.