Add Columns ?

[sbdi]

Sorry to be asking But can someone tell me how to add up all the columns in a table ?

Thanks!

[sbdi]

What I actually mean is I want to total each column. I'm useing SQL 2000. I remember it being a simple function but not sure and cant remember the exact syntax

[MattR]

SELECT SUM( col1 ), SUM( col2 ) ...
FROM yourtable

[sbdi]

Thanks