What is the best way to pass a DataTable to a stored procedure?

Question

I need to pass a DataTable to a stored procedure in MS SQL 2008 to insert multiple rows into a table at the same time. I came across methods that use XML documents to do this and even to pass lists as image data.

What is the best way to do this?

If necessary, provide sample code and / or links.

Answer 1

See Table Parameters and SQL Server 2008: Table Parameters

Answer 2

- - , temp .

, , :

CREATE PROC DoStuff
AS BEGIN
    CREATE TABLE #tobeinserted (Data1 INT, Data2 INT...)
    EXEC InsertRows
END

CREATE PROC InsertRows
AS BEGIN
    INSERT INTO Table1 SELECT * FROM #tobeinserted
END

, , , . , , , () , . , SP.