This made both the application and the server more difficult to program reliably. Sometimes you need to be sure that all alterations to the database are done in one transaction so that, if there is an error, the operation can be entirely rolled back rather than leave the data within the database in an inconsistent state.īefore Table-Valued Parameters were introduced in SQL Server 2008, programmers had to pass multi-row data as serialized, delimited, strings, long parameter lists, or XML. Why was there a problem? If you are forced to send multiple rows of data from a client application to SQL Server by doing several trips to and from the client application, then your application’s performance was likely to suffer and you wouldn’t be able to easily wrap it all in a single transaction. No more looking around for inefficient workarounds or using time consuming methods to meet requirements Table Value Parameters, or TVPs as they are commonly known, have come to the rescue! In layman’s terms, you can now send a whole bunch of rows in one go. Microsoft has finally solved the problem of how to send multiple rows of data to a database without having to do it one row at a time. Using Table Valued Parameters with VB.NET - Simple Talk

Visual basic net using