Passing an entire dataset to a stored procedure in MSSQL 2005

Question

How to pass a data set object to a stored procedure? The dataset contains several tables, and I need to have access to them from SQL.

Answer 1

It looks like you can do this with SQL Server 2008 or newer (at least with DataTable). Here are the links:

http://www.eggheadcafe.com/community/aspnet/10/10138579/passing-dataset-to-stored-procedure.aspx

http://www.sqlteam.com/article/sql-server-2008-table-valued-parameters

Answer 2

Table valued SQL 2008 http://msdn.microsoft.com/en-us/library/bb675163.aspx

SQL CLR http://blogs.msdn.com/b/jpapiez/archive/2005/09/26/474059.aspx

Answer 3

article MusiGenesis

SQL Server 2005 . SQL SQL Server, . VB.Net , SQLBulkCopy .Net SQL , .

, , ,

, . , , MS SQL Server , , .

"" , .

, , ( , , , , , , , , : : )

Temp

, , , , ( db, , , ...).

A good side effect is that such an approach would save the process (which brings you closer to canceling, repeating, and the ability to continue interrupted work).