Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to increase a value by one

Status
Not open for further replies.
davikokar

davikokar

Technical User
May 13, 2004
523
IT
hallo,

I have a table where in one column there are int values. I would like (given the ID of the row) to increase the value by one. Is this possible with one Stored Procedure ? Or do I have to select it, add one, and then update ?

thanks
 
Sort by date Sort by votes
update myTable set ID = ID+1 where ID >=@ID -- this would increase all IDs in the table by 1 starting from the given ID
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
161
drlex
drlex
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
182
drlex
drlex
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
169
kat50
kat50
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
269
markjoseph1232
markjoseph1232
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
137
botatun
botatun

Part and Inventory Search

Sponsor

Back
Top