Insert into question

• carlos cachulo-318532

  Say Hey Kid

  Points: 697

  More actions

  December 20, 2013 at 9:37 am

  #99864

  Hello

  I need to insert records into a table, like this

  TABLE BC

  REF | Design | code

  001 | teste |0001

  001 | teste |0002

  001 |teste |00xx , until it reaches 9999

  with insert into command i only can insert a record of a time, is there another like in a cicle until code=9999

  Thanks ins advance

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  December 20, 2013 at 9:42 am

  #1675212

  Cross post. All replies on http://www.sqlservercentral.com/Forums/Topic1525065-1291-1.aspx

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• carlos cachulo-318532

  Say Hey Kid

  Points: 697

  More actions

  December 20, 2013 at 10:07 am

  #1675226

  sorry, you are right