创建表

 

USE  [DawnAuthority] GO   SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tscore](    name varchar(20), subject varchar(20), score int ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO  insert into [dbo].[tScore] (name,subject,score) values('张三','语文',98) insert into [dbo].[tScore] (name,subject,score) values('张三','数学',80) insert into [dbo].[tScore] (name,subject,score) values('张三','英语',90) insert into [dbo].[tScore] (name,subject,score) values('李四','语文',88) insert into [dbo].[tScore] (name,subject,score) values('李四','数学',86) insert into [dbo].[tScore] (name,subject,score) values('李四','英语',88) insert into [dbo].[tScore] (name,subject,score) values('李明','语文',60) insert into [dbo].[tScore] (name,subject,score) values('李明','数学',86) insert into [dbo].[tScore] (name,subject,score) values('李明','英语',88) insert into [dbo].[tScore] (name,subject,score) values('林风','语文',74) insert into [dbo].[tScore] (name,subject,score) values('林风','数学',99) insert into [dbo].[tScore] (name,subject,score) values('林风','英语',59) insert into [dbo].[tScore] (name,subject,score) values('严明','英语',96) /****** Object:  Table [dbo].[Department]    Script Date: 05/11/2015 23:16:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO