Viewing 4 posts - 1 through 4 (of 4 total)
In the article right below the declaration of the UpdateTableViaTableValuedParameter stored procedure I populated the table valued parameter with data from a table named PODetailtest:
DECLARE @ProcTableParamExample PODetailTableType
INSERT INTO @ProcTableParamExample...
July 12, 2010 at 8:07 am
Thank you for your input. The primary benefit of table valued parameters in my example is eliminating the overhead of multiple calls to the database. For each call there is...
July 10, 2010 at 9:24 am
Thank you. It is true. As the size of your data row grows, the performance boost from table valued parameters may decrease. If the data passed in contains several large...
July 9, 2010 at 9:20 am
In the calling ASP.NET application you can create a ADO.NET datatable object and populate the datatable with the data rows from the grid. The datatable would be passed into the...
July 8, 2010 at 7:56 am
Viewing 4 posts - 1 through 4 (of 4 total)