>>"Microsoft allows someone to pass an ADO.NET datatable"
>>1. Which SQL Server version/year has this feature?
>>2. Do you have a URL or can you post a simple example of how an ADO.NET datatable can be parsed in a stored procedure?
>>
>
>Microsoft added a new Table Type in SQL 2008. It allows someone to pass a table from one stored proc to another (as read-only, because it's essentially being passed by reference), and also to pass an ADO.NET datatable
>
>I wrote about this in a CODE article years ago, it's Tip #5
>
https://www.codemag.com/article/0807041/The-Baker%E2%80%99s-Dozen--13-Tips-for-SQL-Server-2008-and-SSRS-2008Thank you for your reply. I wish I knew about this feature before. My ASP.NET application needs to pass a table to a stored procedure. So, I was serializing the table into an XML string and passing it. Very long and kludgy procedure. Now I am thinking if I should change the approach. Any time I change one thing, I brake something else :) Plus, the time of refactoring this code could be spend on something more productive :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham