Jennifer (gaaneden) wrote,
Jennifer
gaaneden

SQL Query Question

OK. For you smart people who do SQL queries. I want to do a while loop to insert 1000 rows into the DB, one row at a time. I was figuring on doing the classic:


i=0
While (i < 1000)
Begin
Insert Statement
i++
End


However, I can't figure out how to do the i=0 and the i++ in a SQL query correctly.
Subscribe

  • (no subject)

    Bubble & Squeek: Shadowrun and BattleTech, novel and audiobook releases! July was a huge month for me.…

  • (no subject)

    Cover reveal for BattleTech: Crimson Night, the final book of the Rogue Academy trilogy! Isn't it gorgeous? Cover art by the ever-talented Marco…

  • (no subject)

    Blog: Today, Elizabeth Guizzetti tells me about her love of language, how it shifts over the decades, and how she keeps slang of the past alive in…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 13 comments

  • (no subject)

    Bubble & Squeek: Shadowrun and BattleTech, novel and audiobook releases! July was a huge month for me.…

  • (no subject)

    Cover reveal for BattleTech: Crimson Night, the final book of the Rogue Academy trilogy! Isn't it gorgeous? Cover art by the ever-talented Marco…

  • (no subject)

    Blog: Today, Elizabeth Guizzetti tells me about her love of language, how it shifts over the decades, and how she keeps slang of the past alive in…