--用公式
--用公式
create table [year](id int,m1 int,m2 int,m3 int,m4 int,m5 int
,total as isnull(m1,0)+isnull(m2,0)+isnull(m3,0)+isnull(m4,0)+isnull(m5,0)
)
--用公式
create table [year](id int,m1 int,m2 int,m3 int,m4 int,m5 int
,total as isnull(m1,0)+isnull(m2,0)+isnull(m3,0)+isnull(m4,0)+isnull(m5,0)
)
--用公式
create table [year](id int,m1 int,m2 int,m3 int,m4 int,m5 int
,total as isnull(m1,0)+isnull(m2,0)+isnull(m3,0)+isnull(m4,0)+isnull(m5,0)
)
isnull(m1,0)+isnull(m2,0)+isnull(m3,0)+isnull(m4,0)+isnull(m5,0)
select *,total=isnull(m1,0)+isnull(m2,0)+isnull(m3,0)+isnull(m4,0)+isnull(m5,0)
from [year]