SQL Server Performance

Inserting multiple rows

Discussion in 'Analysis Services/Data Warehousing' started by abhi, Jul 3, 2003.

  1. abhi New Member

    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,;
  2. vbkenya New Member

    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.

Share This Page