Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert into question Expand / Collapse
Author
Message
Posted Friday, December 20, 2013 9:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 2:48 AM
Points: 44, Visits: 132
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
Post #1525063
Posted Friday, December 20, 2013 9:42 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:51 PM
Points: 3,354, Visits: 7,251
Cross post. All replies on http://www.sqlservercentral.com/Forums/Topic1525065-1291-1.aspx


Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1525067
Posted Friday, December 20, 2013 10:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 2:48 AM
Points: 44, Visits: 132
sorry, you are right
Post #1525082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse