subtract two column values and store result in another column

Question

0.00/5 (No votes)

See more:

plz can anybody help me i have the one table eg tbl_1 and i have column eg A B C
when i insert into column A and B its result store into C like c=a-b

Posted 28-Sep-15 10:19am

Member 11963532

Add a Solution

Comments

phil.o 28-Sep-15 16:30pm

What have you tried?
Moreover, it is not really clear what you want to achieve.
Do you want to do an arithmetic operation in your INSERT statement?
Or do you want a computed column? (a computed column is a column which automatically computes the result of a given operation)

Member 11963532 28-Sep-15 16:39pm

i have table with field product_price,Advance_income and i have last field name remaing_income i want now here when i insert the value into column product_price and advance_income in the remaing income the result will show between two diffrent values for example
if i put the value in product_price 9000 and i put in advance 1000 then remaing income column insert the value automatically 8000

1 solution

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)

Wendelius · Accepted Answer · 2015-09-28T10:47:00

This could be done in several ways. You could define a trigger making the calculation and storing the result or you could not store the result at all but create a view which would do the calculation. But perhaps the simplest solution would be to use a computed column.

Consider the following

SQL

CREATE TABLE CalcTest (
   A int,
   B int,
   C AS A-B
);

INSERT INTO CalcTest (A, B) VALUES (2,1);
INSERT INTO CalcTest (A, B) VALUES (1,1);
INSERT INTO CalcTest (A, B) VALUES (1,2);
INSERT INTO CalcTest (A, B) VALUES (NULL,1);
INSERT INTO CalcTest (A, B) VALUES (1,NULL);
INSERT INTO CalcTest (A, B) VALUES (NULL,NULL);

SELECT * FROM CalcTest;

The result of the SELECT query would be

A      B      C
----   ----   ----
2      1      1
1      1      0
1      2      -1
NULL   1      NULL
1      NULL   NULL
NULL   NULL   NULL