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:
EBOOZE.COM,;102,WELOVECOOKING.COM,;102,WELOVETOCOOK.COM,;102,WELOVEVIDEO.COM,;102,WELOVEVIDEOS.COM,;102,WEWANTLIQUOR.COM,;102,WIRELESS-NETWORK.ORG,;102,WIRELESS-NETWORKS.ORG,;102,WORLDSFINESTAUTO.COM,;102,WORLDSFINESTCARS.COM,;102,WORLDSFINESTTRUCKS.COM,;102,WORLDSGREATESTATTORNEY.COM,;102,WORLDSGREATESTCARS.COM,;102,WORLDSGREATESTCOMPUTERS.COM,;102,WORLDSGREATESTLAWYERS.COM,;102,WORLDSSAFESTTRUCK.COM,;102,ZCOUNTRY.COM,;102,ZSPORTSHOP.COM,;102,EZHUNTERS.COM,;102,EZLASERS.COM,;102,VIRTUAL-INVESTOR.COM,;102,WELOVEVIDEOGAMES.COM,;102,WEWANTVIDEOGAMES.COM,;

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.
]]>