In this post, we want to discuss send datatable as a parameter in SQL Server. Before we get started, if you want to know about SQL Rowversion, please go through the following article: What is rowversion in SQL Server?


You can add, modify, and delete operations on a set of records in the database using a simple form. The details also need to be shown after adding, updating, and deleting records in a table. And the data table should be given to a stored procedure to perform the operations. This feature will work with SQL Server 2008.


First, create a table type with matching columns that comes from the front-end. In this case:

Write the procedure for the operations.

send datatable as parameter in SQL Server

Leave a Comment