Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 update or Increase 1

Author  Topic 

cutepraba
Yak Posting Veteran

53 Posts

Posted - 2008-09-24 : 10:27:48
Currentvalue of FUSERID is 23

How to increase 1 number in single step

"update NETWORK set FUSERID=+1" something like ??????(didnot work)

please help.

____________
Praba

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-09-24 : 10:30:13
update NETWORK set FUSERID=FUSERID+1

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

cutepraba
Yak Posting Veteran

53 Posts

Posted - 2008-09-24 : 10:32:28
Thank you. It is working

____________
Praba
Go to Top of Page
   

- Advertisement -