“Table-valued parameters (TVPs) in SQL Server 2008 provide an easy way to marshal multiple rows of data from a client application to SQL Server without requiring multiple round trips or special server-side logic for processing the data. TVPs come in handy when you want to code explicit transactions inside of stored procedures, performing multiple data operations as a single unit of work. You can encapsulate multiple rows of data in a single parameterized command. The incoming data rows are stored in a table variable that can then be operated on by using Transact-SQL.”
To learn more, see the blog posting that one of our documentation Writers, Mary Chipman, has written.
About the Author
Mary Chipman is a programmer-writer for the Data Programmability team at Microsoft. She was recently profiled in Women in Technology for TechEd Online at http://msdn.microsoft.com/en-us/events/teched/cc510243.aspx. You can find the online panel she hosted at TechEd 2008 by going to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and searching for: “Are we there yet? Successfully navigating the bumpy road from Access to SQL Server”. Mary will also be presenting at TechEd 2009 (http://www.msteched.com) on the topic of working with SQL Server from Access.