Add columns in SQL Server

Question

I want to add value of 3 columns into one new column but there is a problem! problem is that the value of columns is constant!!! but it should change from one column to another one!!!!

SELECT
    query,
    RESPECT,
    INTELLECT,
    STRENGTH,
    SEL,
    EXPERIENCE,
    GUN,
    DOG,
    CAR,
    CASH,
    BANK_CASH,
    STRENGTH + INTELLECT + SEL AS RES2
 FROM P

If the value of your columns is constant, why would you need to store it in a database? — Jonathan Wood
– Jonathan Wood, Commented Dec 27, 2010 at 4:59
Show the results you are getting and the results you expect, so we can see the difference? — ysth
– ysth, Commented Dec 27, 2010 at 5:34
Question, do different guns give strength bonuses? If so, are they a fixed amount or a % of current strength? If the latter you may want to rethink your computed column. Just sayin — Brian Vander Plaats
– Brian Vander Plaats, Commented Dec 27, 2010 at 18:01

marc_s · Accepted Answer · 2010-12-27 07:32:56Z

1

In SQL Server, you have the concept of a computed column which might work for you here. You can define a new column to be an expression of other columns, e.g. in your case:

ALTER TABLE dbo.P
  ADD RES2 AS Strength + Intellect + Sel

Now, your table P would have a new column RES2 that is the sum of Strength, Intellect and Sel. This column will be different for each row - based on the other values for the three fields that make up RES2.

answered Dec 27, 2010 at 7:32

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add columns in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related