Inserting multiple rows | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Inserting multiple rows

I have to insert multiple insert in sql server. Currently I am using bulk insert statement but for that I have to FTP these data from my web server to database server which I dont like.Could you pls suggest me how can I insert data of array from web form to SQL SErver which should be most optimum and accurate solution? Thanks!
Abhi Example of data format:

Check out the integration of SQL Server, IIS and XML in BOL. Isn’t this the wrong forum for this kind of question? Nathan H.O.