>"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-2008