Update db table old values+number

Question

0.00/5 (No votes)

See more:

Hi, I need some help in updating a database table.
I have got a table with int values and i want to update it
so as each value will be its current value + some number i choose.
the question is how i get the current number efficiently?
thanks in advance :)

Posted 30-May-11 12:08pm

Member 7966831

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Monjurul Habib · Answer 1 · 2011-05-30T12:28:00

Solution 1

DECLARE @ProductID INT
DECLARE @HitCount INT
DECLARE @UPDATEHIT CURSOR
SET @UPDATEHIT = CURSOR FOR
 SELECT ProductID FROM Product
OPEN @UPDATEHIT 
FETCH NEXT
 FROM @UPDATEHIT INTO @ProductID
WHILE @@FETCH_STATUS = 0
 BEGIN
 UPDATE Production.Product
  SET HitCount =(Select HitCount+1 From Product Where ProductID=@ProductID)
 Where ProductID=@ProductID 

FETCH NEXT
FROM @UPDATEHIT INTO @ProductID
 END
CLOSE @UPDATEHIT 
DEALLOCATE @UPDATEHIT

Posted 30-May-11 12:28pm

Monjurul Habib

Comments

Espen Harlinn 30-May-11 19:25pm

A "little" overkill - but it's an aswer - so have my 5

Monjurul Habib 31-May-11 4:03am

thank you. I thought the OP was looking for recursive update, anyway I actually misunderstood the question.

Espen Harlinn · Answer 2 · 2011-05-30T12:31:00

Solution 2

Hw about something like this:

update table1 set value=value+number where id=1

http://www.w3schools.com/sql/sql_update.asp[^]

http://msdn.microsoft.com/en-us/library/ms177523.aspx[^]

Best regards
Espen Harlinn

Posted 30-May-11 12:31pm

Espen Harlinn

Comments

Monjurul Habib 31-May-11 4:04am

nice answer, my 5.

Espen Harlinn 31-May-11 5:25am

Thank you, Monjurul!

Member 7966831 · Answer 3 · 2011-05-30T13:18:00

Solution 3

thx, solved by update table1 set value+='num' where id=1

Posted 30-May-11 13:18pm

Member 7966831

Comments

Espen Harlinn 30-May-11 19:28pm

Thanks, it's custumary to use the "Add Comment" link on the asnwer - and if you're happy with the answer, mark it as the answer. Anyway, happy coding :)