How to find sum of multiple columns in a table in SQL Server 2005

Question

I have a table Emp which has these rows   Emp cd   Val1    Val2    Val3    Total ------- ------- ------- ------- -------  1       1 23    2 23    3 43      2       23 03   12 23   2 92     3       7 23    9 05    13 43    4       03 21   78 23   9 43      I want to find SUM of Val1  Val2  Val3 and which will show in the Total column

User · Answer

Just as a regular SELECT   SELECT     Val1  Val2  Val3     Total   Val1   Val2   Val3 FROM dbo Emp   Or do you want to determine that total and update the table with those values   UPDATE dbo Emp SET Total   Val1   Val2   Val3   If you want to have this total be current at all times - you should have a computed column in your table   ALTER TABLE dbo Emp ADD CurrentTotal AS Val1   Val2   Val3 PERSISTED   Then you will always get the current total - even if the values change   SELECT     Val1  Val2  Val3  CurrentTotal FROM dbo Emp

User · Answer

use a trigges it will work -  - CREATE TRIGGER trigger name BEFORE INSERT ON table name  FOR EACH ROW SET NEW column name3   NEW column name1   NEW column name2   this will only work only when you will insert a row in table not when you will be updating your table for such a pupose  create another trigger of different name and use UPDATE on the place of INSERT in the above syntax

User · Answer

Hi You can use a simple query   select emp cd  val1  val2  val3   val1 val2 val3  as total  from emp    In case you need to insert a new row   insert into emp select emp cd  val1  val2  val3   val1 val2 val3  as total  from emp    In order to update   update emp set total   val1 val2 val3    This will update for all comumns

User · Answer

Easy   SELECT     Val1     Val2     Val3      Val1   Val2   Val3  as  Total  FROM Emp   or if you just want one row   SELECT     SUM Val1  as  Val1      SUM Val2  as  Val2      SUM Val3  as  Val3       SUM Val1    SUM Val2    SUM Val3   as  Total  FROM Emp

User · Answer

Another example using COALESCE  http   sqlmag com t-sql coalesce-vs-isnull  SELECT  COALESCE SUM val1  0    COALESCE SUM val2   0    COALESCE SUM val3   0    COALESCE SUM val4   0   AS  TOTAL  FROM Emp

User · Answer

SELECT Emp cd  Val1  Val2  Val3  SUM Val1   Val2   Val3  AS TOTAL  FROM Emp GROUP BY Emp cd  Val1  Val2  Val3

User · Answer

Try this   select sum num tax amount num total amount  from table name

User · Answer

You must also be aware of null records   SELECT   ISNULL Val1 0    ISNULL Val2 0    ISNULL Val3 0   as  Total  FROM Emp   Usage of ISNULL   ISNULL col Name  replace value

[sql] How to find sum of multiple columns in a table in SQL Server 2005?

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005