Results 1 to 3 of 3

Thread: SQL for inserting 1000's of numbers [resolved]

Threaded View

  1. Dec 20th, 2006, 09:27 AM #1
    Oliver1
    Oliver1 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Posts
    262

    Resolved SQL for inserting 1000's of numbers [resolved]

    I want to insert values from
    712000 to 713999 into a database

    eg I want to loop through

    x = 712000
    while x < 714000
    INSERT INTO tbRoute
    (val1)
    VALUES (x)
    x = x + 1
    loop

    Can I do this in SQL (I am using SQL server), rather than having to code a trivial program.
    Thanks
    Last edited by Oliver1; Dec 21st, 2006 at 10:46 AM.
    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