Results 1 to 2 of 2

Thread: Bulk insert in database.

  1. Aug 26th, 2011, 04:45 AM #1
    vijy
    vijy is offline

    Thread Starter
    Fanatic Member vijy's Avatar
    Join Date
    May 2007
    Location
    India
    Posts
    548

    Bulk insert in database.

    Am using Sql server 2008,

    i have three columns in a table.. i need to insert 50 lak records.. do i want to run loop like below or any other way..

    for i as integer = 1 to 500000
    'insert query
    next
    Visual Studio.net 2010
    If this post is useful, rate it

    Reply With Quote Reply With Quote
  2. Aug 26th, 2011, 04:58 AM #2
    Joacim Andersson
    Joacim Andersson is offline
    I'm about to be a PowerPoster! Joacim Andersson's Avatar
    Join Date
    Jan 1999
    Location
    Sweden
    Posts
    14,649

    Re: Bulk insert in database.

    Have a look at the SqlBulkCopy class.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width