How Can I Add Data In Columns Of Database To Get Results In Another Column ?

Question

1.00/5 (2 votes)

See more:

The db might look like this

MARKS1  MARKS2 TOTAL
 10     12      22

Thank you in advance

[edit]SHOUTING removed, Code block added - OriginalGriff[/edit]

Posted 22-Jan-16 8:01am

Shashidhara Vyakaranal

Updated 22-Jan-16 8:13am

OriginalGriff

v2

Add a Solution

Comments

[no name] 22-Jan-16 14:08pm

You provided the column with data. That is ok. But what do you want exactly?

ZurdoDev 22-Jan-16 14:11pm

Your question does not make any sense. Explain where you are stuck and what you need. And stop using all CAPS, it's considered shouting and rude.

OriginalGriff 22-Jan-16 14:13pm

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.

jgakenhe 22-Jan-16 14:31pm

Not exactly sure what you are wanting but it sounds like you want a Computed Column.

Here is an example of a Computed Column: https://www.mssqltips.com/sqlservertip/2481/getting-creative-with-computed-columns-in-sql-server/

* Personally, I would not use them. I would do any computations in either my application or if that is not possible, then my SQL query.

Member 12001186 22-Jan-16 16:34pm

If I understand correctly something like:

SELECT firstname, lastname, firstname+lastname as 'fullname' FROM dbo.Users;

You can use computed columns, functions etc. as well.

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)

RDBurmon · Accepted Answer · 2016-01-26T05:38:00

Solution 1

Here you go

SQL

CREATE TABLE tblMarks(Mark1 INT,Mark2 INT,Total AS Mark1 + Mark2)

INSERT INTO tblMarks
SELECT 10,10

SELECT * FROM tblMarks

Result would be
Mark1 Mark2 Total
10 10 20

Hope this helps if yes then vote and accept the solution
Thanks - RDBurmon

Posted 26-Jan-16 5:38am

RDBurmon