Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    8

    Unanswered: How to Insert Records in a Loop

    I need to insert a batch 5000 records into a table. Most of the fields will be the same for every record and can be hard-coded in the insert statement, except one which is a number field, and will be sequentially incremented from X to X+5000.

    Is there a loop or another way to accomplish this? Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    How about a sequence?

Posting Permissions

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