CREATE TABLE [dbo].[resultinfo] (
[stu_id] [int] NOT NULL ,
[stu_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[stu_class] [int] NULL ,
[math] [int] NULL ,
[english] [int] NULL ,
[Cprogrammer] [int] NULL ,
[os] [int] NULL ,
[datastruct] [int] NULL ,
[total] as math+english+Cprogrammer+os+datastruct,
) ON [PRIMARY]
GO
[stu_id] [int] NOT NULL ,
[stu_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[stu_class] [int] NULL ,
[math] [int] NULL ,
[english] [int] NULL ,
[Cprogrammer] [int] NULL ,
[os] [int] NULL ,
[datastruct] [int] NULL ,
[total] as math+english+Cprogrammer+os+datastruct,
) ON [PRIMARY]
GO
[stu_id] [int] NOT NULL ,
[stu_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[stu_class] [int] NULL ,
[math] [int] NULL ,
[english] [int] NULL ,
[Cprogrammer] [int] NULL ,
[os] [int] NULL ,
[datastruct] [int] NULL ,
[total] as math+english+Cprogrammer+os+datastruct,
) ON [PRIMARY]
GO