if you using SQL Server 2008 and above , you can pass a data table to store procedure.
1st create a table type in sql server
Then use this new type as a readonly parameter.
and you can use this parameter.
and from dot not pass a datatable
Oswaldlily, if this helps please login to Mark As Answer. |
Reply | Alert Moderator