Increment In Database Values

Question

5.00/5 (1 vote)

See more:

Hello Friends....!!!

I have a Database in which some numbers are in 10 column.

I want to increment a users 2nd column by 1, third column by 4 , fourth column by 3 and 5th column by 6 etc....

Now i am using this logic....

1). I will retrieve values in variables from database
2) Increment in these variables
3). Update the data base

Please help me i am new here !!!!!

Posted 24-Dec-11 21:58pm

Pr!y@

Updated 11-Jan-13 0:38am

v2

Add a Solution

Comments

Amir Mahfoozi 25-Dec-11 4:19am

It seems that a bad designed table beside a bad designed application going to mix together. If it is a serious project leave it to a skilled one but if it is a home work try to analyze the problem with some consultation from an expert. Excuse me that I was so frank.

Pr!y@ 25-Dec-11 12:38pm

Yes you are right but i will tell you soon that i have created a good website,
i hope so,,,,,

Amir Mahfoozi 25-Dec-11 12:52pm

I hope so too, And I will be very glad to hear that ;) Good Luck. :)

Pr!y@ 26-Dec-11 0:26am

Thanks Sir

Amir Mahfoozi 26-Dec-11 2:07am

Your language is very near to Farsi :)
But OK I got it. Here is the right place to ask but I meant that you need to experience and study more.
Good Luck ;)

Pr!y@ 28-Dec-11 2:29am

No sir i am Indian

Iraado me ho dam to hr mushkil hoti hai aasaan !!!.....
Means if your thinking is strong then everything is easy !!!

Actually sir i am new here
and I want more and more knowledge
so i joined this forum

You people are my senior, I respect to all

Nice to Talk with you !!!! :)

2 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)

OriginalGriff · Accepted Answer · 2011-12-24T22:18:00

I would write a stored procedure to do it: that way it is all done within the database, and there is no risk of other people doing the same thing, and you ending up with wrong values.

SQL

USE [myDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [proc_addtovals]
AS
UPDATE myTable SET column2=column2+1, column3=column3+4

Wendelius · Accepted Answer · 2011-12-24T23:38:00

Never change the values via irrelevant controls. As OriginalGriff showed, you can set the increment values to the SQL statement and let the database do the calculations.

If the amount of increment is user defined, then use parameters to define the increment:

SQL

UPDATE TableName SET Field1 = Field1 + @increment;

See: SqlParameter[^]

Increment In Database Values

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0