T SQL syntax for creating table : I Need to make a table of student marks list.
in one column the data need to be sum of the columns in the same row
ex roll_no  Maths1   maths2    physics    total
   12        48       50       60         158
how can i create a table for the above solution in sql