菜鸟问题

INSERT INTO test.dbo.高考 ([姓名],[准考证],[语文],[数学],[英语],[+1课程],[综合],[加分],[总分]) VALUES
           ('Marry'
           ,000001
           ,100
           ,100
           ,120
           ,123
           ,120
           ,0
           ,0)
总么写一句语句,直接把总分加出来,谢谢帮忙了

 

create table 高考 ([姓名] varchar(20),[准考证] varchar(20),[语文] float,[数学] float,[英语] float,[+1课程] float,[综合] float,[加分] float,[总分] as [语文]+[数学]+[英语]+[+1课程]+[综合]+[加分]
)
go
INSERT INTO 高考 ([姓名],[准考证],[语文],[数学],[英语],[+1课程],[综合],[加分]) VALUES
           ('Marry'
           ,000001
           ,100
           ,100
           ,120
           ,123
           ,120
           ,0
          )
go
select * from 高考
go
drop table 高考

/*
姓名                   准考证                  语文                     数学                     英语                     +1课程                   综合                     加分                     总分
-------------------- -------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ----------------------
Marry                1                    100                    100                    120                    123                    120                    0                      563

(1 行受影响)

*/