Some time we need to pass a tabular form data to our database. one option is to using loop in Datatable and on every iteration we have to make a Database call. But this approach is not too good and ...
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...
I created a TABLE Type and am trying to pass it into a stored procedure with other parameters, e.g. a VARCHAR(45) field. If I call the stored procedure with just the Type as a parameter. it works OK.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback