上机练习

最新推荐文章于 2022-04-28 22:51:22 发布
最新推荐文章于 2022-04-28 22:51:22 发布
阅读量667 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_36074056/article/details/53289533
版权 
USE [MySchool]
GO
/****** Object:  Table [dbo].[Grade]    Script Date: 2016/11/21 15:19:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Grade](
	[GradeId] [int] IDENTITY(1,1) NOT NULL,
	[GradeName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Grade] PRIMARY KEY CLUSTERED 
(
	[GradeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Result]    Script Date: 2016/11/21 15:19:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Result](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[StudentNo] [nvarchar](50) NOT NULL,
	[SubjectId] [int] NOT NULL,
	[StudentResult] [int] NULL,
	[ExamDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_Result] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Student]    Script Date: 2016/11/21 15:19:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Student](
	[StudentNo] [nvarchar](50) NOT NULL,
	[LoginPwd] [nvarchar](20) NOT NULL CONSTRAINT [DF_Student_LoginPwd]  DEFAULT ((123456)),
	[StudentName] [nvarchar](50) NOT NULL,
	[Sex] [char](2) NOT NULL,
	[GradeId] [int] NOT NULL,
	[Phone] [nvarchar](255) NOT NULL,
	[Address] [nvarchar](255) NULL CONSTRAINT [DF_Student_Address]  DEFAULT (N'学生宿舍'),
	[BornDate] [datetime] NULL,
	[Email] [nvarchar](50) NULL,
 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 
(
	[StudentNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Subject]    Script Date: 2016/11/21 15:19:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Subject](
	[SubjectId] [int] IDENTITY(1,1) NOT NULL,
	[SubjectName] [nvarchar](20) NOT NULL,
	[ClassHour] [int] NOT NULL,
	[GradeId] [int] NOT NULL,
 CONSTRAINT [PK_Subject] PRIMARY KEY CLUSTERED 
(
	[SubjectId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[Grade] ON 

INSERT [dbo].[Grade] ([GradeId], [GradeName]) VALUES (1, N'S1')
INSERT [dbo].[Grade] ([GradeId], [GradeName]) VALUES (2, N'S2')
INSERT [dbo].[Grade] ([GradeId], [GradeName]) VALUES (3, N'Y2')
SET IDENTITY_INSERT [dbo].[Grade] OFF
SET IDENTITY_INSERT [dbo].[Result] ON 

INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (1, N'S2102001', 3, 76, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (2, N'S2102002', 3, 90, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (3, N'S2102003', 3, 99, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (4, N'S2102004', 3, 79, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (5, N'S2102005', 3, 80, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (6, N'S2102006', 3, 61, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (7, N'S2102007', 3, 82, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (8, N'S2102008', 3, 35, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (9, N'S2102009', 3, 64, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (10, N'S2102010', 3, 65, CAST(N'2013-09-13 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (11, N'S1101001', 1, 80, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (12, N'S1101002', 1, 61, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (13, N'S1101003', 1, 82, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (14, N'S1101004', 1, 55, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (15, N'S1101005', 1, 64, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (16, N'S1101006', 1, 65, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (17, N'S1101007', 1, 88, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (18, N'S1101008', 1, 67, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (19, N'S1101009', 1, 68, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (20, N'S1101010', 1, 44, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (21, N'S1101011', 1, 89, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (22, N'S1101012', 1, 71, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (23, N'S1101013', 1, 44, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (24, N'S1101014', 1, 77, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (25, N'S1101015', 1, 86, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (26, N'S1101016', 1, 75, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (27, N'S1101017', 1, 76, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (28, N'S1101018', 1, 90, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (29, N'S1101019', 1, 99, CAST(N'2013-12-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (30, N'S1101020', 1, 79, CAST(N'2013-12-23 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (31, N'S1101001', 2, 80, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (32, N'S1101002', 2, 61, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (33, N'S1101003', 2, 82, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (34, N'S1101004', 2, 35, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (35, N'S1101005', 2, 64, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (36, N'S1101006', 2, 65, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (37, N'S1101007', 2, 88, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (38, N'S1101008', 2, 67, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (39, N'S1101009', 2, 68, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (40, N'S1101010', 2, 44, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (41, N'S1101011', 2, 75, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (42, N'S1101012', 2, 71, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (43, N'S1101013', 2, 44, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (44, N'S1101014', 2, 88, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (45, N'S1101015', 2, 86, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (46, N'S1101016', 2, 75, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (47, N'S1101017', 2, 38, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (48, N'S1101018', 2, 90, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (49, N'S1101019', 2, 99, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (50, N'S1101020', 2, 79, CAST(N'2013-11-15 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (51, N'S1101011', 1, 68, CAST(N'2013-07-01 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (52, N'S1101014', 1, 75, CAST(N'2013-07-01 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (53, N'S1101008', 2, 45, CAST(N'2013-07-01 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (54, N'S1101014', 2, 60, CAST(N'2013-07-01 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (55, N'S2102001', 8, 99, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (56, N'S2102002', 8, 55, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (57, N'S2102003', 8, 60, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (58, N'S2102004', 8, 70, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (59, N'S2102005', 8, 85, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (60, N'S2102006', 8, 88, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (61, N'S2102007', 8, 95, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (62, N'S2102008', 8, 44, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (63, N'S2102009', 8, 68, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (64, N'S2102010', 8, 88, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (65, N'S2102011', 8, 88, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (66, N'S1101001', 3, 88, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (67, N'S1101002', 3, 50, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (68, N'S1101003', 3, 44, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (69, N'S1101004', 3, 77, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (70, N'S1101005', 3, 75, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (71, N'S1101006', 3, 63, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (72, N'S1101007', 3, 15, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (73, N'S1101008', 3, 55, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (74, N'S1101009', 3, 69, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (75, N'S1101010', 3, 90, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (76, N'S1101011', 3, 95, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (77, N'S1101001', 4, 99, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (78, N'S1101002', 4, 60, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (79, N'S1101003', 4, 65, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (80, N'S1101004', 4, 77, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (81, N'S1101005', 4, 75, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (82, N'S1101006', 4, 63, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (83, N'S1101007', 4, 45, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (84, N'S1101008', 4, 55, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (85, N'S1101009', 4, 69, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (86, N'S1101010', 4, 90, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
INSERT [dbo].[Result] ([Id], [StudentNo], [SubjectId], [StudentResult], [ExamDate]) VALUES (87, N'S1101011', 4, 99, CAST(N'2013-03-22 00:00:00' AS SmallDateTime))
SET IDENTITY_INSERT [dbo].[Result] OFF
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101001', N'228996245', N'金蝶', N'男', 1, N'717215147', N'天津市河西区', CAST(N'1995-01-22 00:00:00.000' AS DateTime), N'okiwcydml@ryhlo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101002', N'228996246', N'洛飞', N'女', 1, N'666762663', N'天津市南开区', CAST(N'1995-04-22 00:00:00.000' AS DateTime), N'jnqlpkdwb@nsjpt.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101003', N'228996247', N'凌辉', N'女', 1, N'353149818', N'北京市海淀区成府路', CAST(N'1998-06-17 00:00:00.000' AS DateTime), N'eepispykh@oitbl.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101004', N'228996251', N'白燕', N'男', 1, N'676151367', N'学生宿舍', CAST(N'1995-11-14 00:00:00.000' AS DateTime), N'cxmnnrhfn@sjsam.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101005', N'228996252', N'夏一桐', N'男', 1, N'397739963', N'北京市朝阳区大屯', CAST(N'1994-11-25 00:00:00.000' AS DateTime), N'npgiygxox@ootml.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101006', N'228996253', N'欧阳燕飞', N'男', 1, N'13512345678', N'河南省南阳市', CAST(N'1992-08-31 00:00:00.000' AS DateTime), N'dkwkiqbrj@yrkro.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101007', N'228996254', N'孟祥亚', N'男', 1, N'13512345679', N'河南省洛阳市涧西区', CAST(N'1998-05-07 00:00:00.000' AS DateTime), N'gekdinmky@ijisq.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101008', N'228996257', N'凌洋', N'女', 1, N'15812345680', N'湖南省长沙', CAST(N'1995-02-12 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101009', N'228996259', N'杨阳', N'男', 1, N'13512345681', N'上海市长虹区', CAST(N'1994-04-03 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101010', N'228996263', N'方晴', N'男', 1, N'13412345682', N'山东省聊城市', CAST(N'1995-09-24 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101011', N'228996267', N'圆荷', N'女', 1, N'13512344483', N'河北省石家庄', CAST(N'1994-05-29 00:00:00.000' AS DateTime), N'idfwxlbjr@bkxko.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101012', N'228996270', N'崔今生', N'女', 1, N'13512345684', N'河北省邯郸市', CAST(N'1995-03-20 00:00:00.000' AS DateTime), N'qrakldetd@ogtso.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101013', N'228996271', N'姜北', N'男', 1, N'578346237', N'学生宿舍', CAST(N'1995-04-09 00:00:00.000' AS DateTime), N'soppebati@hwxpo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101014', N'228996273', N'姜丫丫', N'男', 1, N'926457035', N'北京市朝阳区慧忠里', CAST(N'1997-09-06 00:00:00.000' AS DateTime), N'rfkhgcxhy@oomkw.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101015', N'228996274', N'孙河', N'男', 1, N'895684949', N'北京市通州区', CAST(N'1995-09-07 00:00:00.000' AS DateTime), N'kdaqojpjj@olmcy.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101016', N'228996275', N'王可', N'男', 1, N'328884827', N'北京市石景山', CAST(N'1995-09-08 00:00:00.000' AS DateTime), N'bojzfsixf@qjwgw.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101017', N'228996276', N'赵七', N'女', 1, N'511686053', N'北京市海淀区中关村', CAST(N'1990-09-09 00:00:00.000' AS DateTime), N'ltshcitdp@qdpeh.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101018', N'228996279', N'买燕', N'男', 1, N'155426854', N'河南省周口', CAST(N'1995-09-10 00:00:00.000' AS DateTime), N'rmpnhbiop@mwrom.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101019', N'228996281', N'冯征', N'男', 1, N'436987577', N'湖北省襄樊', CAST(N'1992-09-10 00:00:00.000' AS DateTime), N'mdokehdic@omcte.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S1101020', N'228996283', N'冯中', N'男', 1, N'786340887', N'天津市南开区', CAST(N'1995-09-12 00:00:00.000' AS DateTime), N'lwspyimci@kcplq.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102001', N'228996284', N'包卫丽', N'女', 2, N'13875940258', N'湖州德清', CAST(N'1995-09-13 00:00:00.000' AS DateTime), N'sakuralove2829@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102002', N'228996285', N'吴可鹏', N'男', 2, N'13875940259', N'学生宿舍', CAST(N'1996-09-13 00:00:00.000' AS DateTime), N'peggyonhkhk@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102003', N'228996287', N'於炉冰', N'男', 2, N'13875940260', N'学生宿舍', CAST(N'1995-09-15 00:00:00.000' AS DateTime), N'yyyyyyyyyyu@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102004', N'228996290', N'朱月清', N'女', 2, N'13875940261', N'衢州开化', CAST(N'1995-09-16 00:00:00.000' AS DateTime), N'yinyin01094@yahoo.com.hk')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102005', N'228996291', N'赵献星', N'男', 2, N'13875940262', N'杭州建德', CAST(N'1995-02-12 00:00:00.000' AS DateTime), N'ada19262002@hotmail.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102006', N'228996292', N'吴宝玉', N'女', 2, N'13875940263', N'湖州埭溪', CAST(N'1992-02-13 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102007', N'228996293', N'胡梦秋', N'女', 2, N'13875940264', N'杭州临安', CAST(N'1995-02-14 00:00:00.000' AS DateTime), N'bobo_lok13@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102008', N'228996302', N'吴春红', N'女', 2, N'13875940265', N'金华金东区', CAST(N'1995-02-15 00:00:00.000' AS DateTime), N'yintakli@yahoo.com.hk')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102009', N'228996304', N'张文俊', N'男', 2, N'13974807750', N'绍兴上虞', CAST(N'1998-02-16 00:00:00.000' AS DateTime), N'natalielam01098@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102010', N'228996305', N'乐晓燕', N'男', 2, N'13007426477', N'台州三门', CAST(N'1995-02-17 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102011', N'228996307', N'裴珍', N'男', 2, N'13873140386', N'北京大兴区', CAST(N'1994-12-01 00:00:00.000' AS DateTime), N'lingling52030996@hotmail.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102012', N'228996308', N'周巧飞', N'男', 2, N'13107428484', N'学生宿舍', CAST(N'1994-12-02 00:00:00.000' AS DateTime), N'yuenfunki@yahoo.com.hk')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102013', N'228996309', N'王晓文', N'男', 2, N'13574220088', N'杭州建德', CAST(N'1997-12-03 00:00:00.000' AS DateTime), N'kykwok9@hotmail.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102014', N'228996312', N'卢凤华', N'女', 2, N'13574220089', N'衢州开化', CAST(N'1994-12-04 00:00:00.000' AS DateTime), N'sulia123@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102015', N'228996316', N'胡灵', N'女', 2, N'13574220090', N'台州天台', CAST(N'1994-12-05 00:00:00.000' AS DateTime), N'chankwaiching@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102016', N'228996317', N'盛立', N'男', 2, N'13574220091', N'安徽阜阳', CAST(N'1994-12-06 00:00:00.000' AS DateTime), N'yankchan2004@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102017', N'228996318', N'吴孝红', N'男', 2, N'13678945617', N'黑龙江哈尔滨', CAST(N'1994-12-07 00:00:00.000' AS DateTime), N'ayako04620@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102018', N'228996323', N'曾飞燕', N'男', 2, N'13678945618', N'杭州临安', CAST(N'1998-12-08 00:00:00.000' AS DateTime), N'ayako04620@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102019', N'228996324', N'陈科', N'男', 2, N'13678945619', N'新疆乌鲁木齐', CAST(N'1994-08-25 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'S2102020', N'228996325', N'严丽丽', N'男', 2, N'13678945620', N'新疆伊宁', CAST(N'1995-07-17 00:00:00.000' AS DateTime), N'phoebe_swy@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003001', N'228996326', N'孙瑞晨', N'男', 3, N'13574220096', N'金华兰溪', CAST(N'1994-07-17 00:00:00.000' AS DateTime), N'faat11@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003002', N'228996327', N'黄金宵', N'男', 3, N'13574220097', N'绍兴诸暨', CAST(N'1994-04-08 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003003', N'228996329', N'陈婷婷', N'男', 3, N'13574220098', N'衢州常山', CAST(N'1994-06-20 00:00:00.000' AS DateTime), N'mandylau1986@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003004', N'228996334', N'章巧丹', N'女', 3, N'13174220099', N'宁波宁海', CAST(N'1994-08-22 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003005', N'228996340', N'刘丽云 ', N'女', 3, N'13174220100', N'学生宿舍', CAST(N'1994-01-25 00:00:00.000' AS DateTime), N'raymondchoi04@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003006', N'228996341', N'丁 亮', N'男', 3, N'13174220101', N'嘉兴嘉善', CAST(N'1994-03-28 00:00:00.000' AS DateTime), N'tlh10202003@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003007', N'228996342', N'李明华', N'女', 3, N'13574220102', N'金华兰溪', CAST(N'1993-06-01 00:00:00.000' AS DateTime), N'mimichoi276@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003008', N'228996343', N' 金 晶', N'男', 3, N'13574220103', N'学生宿舍', CAST(N'1993-06-02 00:00:00.000' AS DateTime), N'mapdhhljp@ncqfg.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003009', N'228996346', N'张世庆', N'男', 3, N'13574220104', N'湖州双林', CAST(N'1995-06-03 00:00:00.000' AS DateTime), N'godspnrel@eblox.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003010', N'228996348', N'方汝滔', N'男', 3, N'13574220105', N'衢州常山', CAST(N'1993-06-04 00:00:00.000' AS DateTime), N'wieiowzmq@jplop.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003011', N'228996349', N'王 波', N'男', 3, N'13574220106', N'北京朝阳区', CAST(N'1993-06-05 00:00:00.000' AS DateTime), N'wengsanc14l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003012', N'228996351', N'颜俊俊', N'男', 3, N'13374220107', N'衢州龙游', CAST(N'1993-06-06 00:00:00.000' AS DateTime), N'wengsanc15l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003013', N'228996352', N'刘雪琼', N'女', 3, N'13374220108', N'绍兴嵊州', CAST(N'1994-09-08 00:00:00.000' AS DateTime), N'wengsanc16l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003014', N'228996353', N'胡晓奕', N'女', 3, N'13374220109', N'学生宿舍', CAST(N'1994-12-06 00:00:00.000' AS DateTime), N'wengsanc17l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003015', N'228996357', N'王莉莉', N'女', 3, N'13374220110', N'湖州杨家埠', CAST(N'1995-01-20 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003016', N'228996362', N'金辉', N'男', 3, N'13574220111', N'台州温岭', CAST(N'1994-07-07 00:00:00.000' AS DateTime), N'wengsanc19l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003017', N'228996364', N'郑峰', N'男', 3, N'13574220112', N'北京海淀区', CAST(N'1994-12-07 00:00:00.000' AS DateTime), N'wengsanc20l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003018', N'228996365', N'何国英', N'男', 3, N'13574220113', N'台州温岭', CAST(N'1993-05-14 00:00:00.000' AS DateTime), NULL)
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003019', N'228996370', N'方振', N'男', 3, N'13574220114', N'台州三门', CAST(N'1995-02-11 00:00:00.000' AS DateTime), N'wengsanc22l@yahoo.com')
INSERT [dbo].[Student] ([StudentNo], [LoginPwd], [StudentName], [Sex], [GradeId], [Phone], [Address], [BornDate], [Email]) VALUES (N'Y21003020', N'228996371', N'雷应飞', N'男', 3, N'13574220115', N'湖州吴兴区', CAST(N'1994-03-31 00:00:00.000' AS DateTime), N'wengsanc23l@yahoo.com')
SET IDENTITY_INSERT [dbo].[Subject] ON 

INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (1, N'使用C#语言开发数据库应用系统', 36, 1)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (2, N'深入.NET平台和C#编程', 76, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (3, N'设计MySchool数据库', 42, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (4, N'基于.NET平台的软件系统分层开发', 44, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (5, N'面向对象程序设计', 59, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (6, N'使用JavaScript增强交互效果', 40, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (7, N'使用Java EE技术开发新闻发布系统', 55, 2)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (8, N'使用ASP.NET技术开发网上书店', 86, 3)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (9, N'开发基于Ajax和控件技术的Web应用系', 60, 3)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (10, N'使用Java框架技术开发网上信息发布系统', 52, 3)
INSERT [dbo].[Subject] ([SubjectId], [SubjectName], [ClassHour], [GradeId]) VALUES (11, N'使用Java企业级技术开发企业应用', 68, 3)
SET IDENTITY_INSERT [dbo].[Subject] OFF
ALTER TABLE [dbo].[Result]  WITH CHECK ADD  CONSTRAINT [FK_Result_Student] FOREIGN KEY([StudentNo])
REFERENCES [dbo].[Student] ([StudentNo])
GO
ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_Result_Student]
GO
ALTER TABLE [dbo].[Result]  WITH CHECK ADD  CONSTRAINT [FK_Result_Subject] FOREIGN KEY([SubjectId])
REFERENCES [dbo].[Subject] ([SubjectId])
GO
ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [FK_Result_Subject]
GO
ALTER TABLE [dbo].[Student]  WITH CHECK ADD  CONSTRAINT [FK_Student_Grade] FOREIGN KEY([GradeId])
REFERENCES [dbo].[Grade] ([GradeId])
GO
ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [FK_Student_Grade]
GO
ALTER TABLE [dbo].[Subject]  WITH CHECK ADD  CONSTRAINT [FK_Subject_Grade] FOREIGN KEY([GradeId])
REFERENCES [dbo].[Grade] ([GradeId])
GO
ALTER TABLE [dbo].[Subject] CHECK CONSTRAINT [FK_Subject_Grade]
GO
ALTER TABLE [dbo].[Result]  WITH CHECK ADD  CONSTRAINT [CK_Result] CHECK  (([StudentResult]>(0) AND [StudentResult]<(100)))
GO
ALTER TABLE [dbo].[Result] CHECK CONSTRAINT [CK_Result]
GO
ALTER TABLE [dbo].[Student]  WITH CHECK ADD  CONSTRAINT [CK_Student_Email] CHECK  (([Email] like '%@%'))
GO
ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [CK_Student_Email]
GO
ALTER TABLE [dbo].[Student]  WITH CHECK ADD  CONSTRAINT [CK_Student_LoginPwd] CHECK  ((len([LoginPwd])>=(6)))
GO
ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [CK_Student_LoginPwd]
GO
ALTER TABLE [dbo].[Student]  WITH CHECK ADD  CONSTRAINT [CK_Student_Sex] CHECK  (([Sex]='男' OR [Sex]='女'))
GO
ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [CK_Student_Sex]
GO
ALTER TABLE [dbo].[Subject]  WITH CHECK ADD  CONSTRAINT [CK_Subject] CHECK  (([ClassHour]>(0)))
GO
ALTER TABLE [dbo].[Subject] CHECK CONSTRAINT [CK_Subject]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年级编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Grade', @level2type=N'COLUMN',@level2name=N'GradeId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年级名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Grade', @level2type=N'COLUMN',@level2name=N'GradeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标识列' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Result', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Result', @level2type=N'COLUMN',@level2name=N'StudentNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属科目' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Result', @level2type=N'COLUMN',@level2name=N'SubjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Result', @level2type=N'COLUMN',@level2name=N'StudentResult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'考试日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Result', @level2type=N'COLUMN',@level2name=N'ExamDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'StudentNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'LoginPwd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'StudentName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'Sex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所在年级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'GradeId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'现住址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'Address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'BornDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Student', @level2type=N'COLUMN',@level2name=N'Email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Subject', @level2type=N'COLUMN',@level2name=N'SubjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Subject', @level2type=N'COLUMN',@level2name=N'SubjectName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学时' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Subject', @level2type=N'COLUMN',@level2name=N'ClassHour'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属年级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Subject', @level2type=N'COLUMN',@level2name=N'GradeId'
GO
SELECT * FROM Student 
SELECT  StudentName,Phone FROM  Student  WHERE GradeId=2
select StudentNo, LoginPwd, StudentName, Sex, GradeId, Phone, Address, BornDate, Email
FROM Student WHERE GradeId=1 AND Sex='女'
SELECT  SubjectName FROM Subject WHERE ClassHour>60
SELECT SubjectName FROM Subject WHERE GradeId=1
SELECT StudentName,Sex='男',Address
FROM Student  WHERE GradeId=2
SELECT StudentName FROM Student WHERE GradeId=2 and BornDate>'1990'
SELECT StudentResult from Result where ExamDate='2013-9-13'and SubjectId='3'

SELECT * FROM Student WHERE GradeId=1
ORDER BY BornDate 
SELECT * from Result where SubjectId=1 
ORDER BY StudentResult desc,ExamDate
SELECT TOP 5 StudentResult from Result WHERE SubjectId=2
ORDER BY StudentResult desc
SELECT TOP 1 SubjectName from Subject WHERE SubjectId=3
ORDER BY ClassHour desc
SELECT TOP 1 StudentName GradeId from Student
ORDER BY BornDate desc
SELECT TOP 1 StudentResult from Result where ExamDate='2013-3-22'
ORDER BY StudentResult ASC
SELECT * from Result WHERE StudentNo='S1101003'
ORDER BY StudentNo desc
SELECT Top 1 StudentResult,ExamDate,StudentNo from Result WHERE StudentNo='S1101003'

那抹绯红乀
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Excel上机练习题，含详细操作步骤
12-09
Excel上机练习，里面有详细的操作步骤
java上机练习题
11-01
一个非常具有代表性的Java练习题，想要验证一下自己的Java变成能力，这是非常好的试题
office上机练习题
02-20
word和excel2003比较好的上机练习
HTML上机练习
08-18
北大青鸟 S2 HTML上机练习
Linux上机练习题
04-08
这是一个很简单的Linux上机练习题，答案不是很完整，感兴趣的可以看看
JavaWeb上机练习11.zip
04-20
【原创作者田超凡，未经许可请勿转发，侵权仿冒必究】
Fortran上机练习
07-06
Fortran上机练习。
上机练习12.9
12-09
上机练习12.9
HTML第四章上机练习4
qq_36074163的博客
10-14 7082
上机练习4 开心餐厅，让你可以开心的烹饪美味佳肴，从一个简洁的小餐厅起步，逐步打造自己的餐饮大食代。 烹饪美食，雇佣好友帮忙，装修个性餐厅，获得顾客美誉。 步步精心经营，细心打理，我们都能成为餐饮大亨哦。 如何做菜?
上机练习题
zuis_huai的博客
12-20 1908
上机练习题1.根据输入的苹果和香蕉的数量，用JS代码实现点击“计算”按钮时，计算并显示总重量和总价钱。2.根据输入的半径值，用JS代码实现点击“计算”按钮时，计算并显示周长和面积。3.写HTML代码实现下面截图效果的页面。（表格背景颜色为99FFFF，并且表格在网页内居中对齐）4. 用写HTML代码实现下面截图效果的页面5.设计函数消除数组中重复的元素6.设计一函数计算数组中索引为奇数的元素之和。7．小王今年23岁，他计划将10000元存为一年定期，利率为3%，按复利计算，请设计函数计算他60岁时这个存单的
浅谈五种SqlServer存储过程分页方式
codeRandom
04-08 646
浅谈五种SqlServer存储过程分页方式基础数据方式方式一：利用 Select Top 和 Select Not In方式二：利用 Select Top 和 Max(列键) 函数方式三：利用 Select Top 和 中间变量方式四：利用 Row_Number()方式五：利用 CTE 和 Row_Number()执行测试统计结果参考资料Digression 基础数据 --定义表结构 CREATE...
上机练习(网络编程)
咖啡有点苦的博客
04-28 145
1.编程实现客户端与服务器的一次会话 /** * 练习: * ▪ 编程实现客户端与服务器的一次会话 * * @Description: networkprogramPPT * @author: Axu * @date:2022/4/24 8:47 */ public class ClientAndServerCommunication { @Test public void client(){ Socket socket= null; ...
建表，插入标识列，自动生成id
YongYu_IT的专栏
03-26 1105
USE [yuyongTest] GO --go：立即执行。go语句将SQL Server脚本分段。执行完一段之后才可以执行下一段，段与段之间完全独立。跨越go语句的临时变量不可通用。 declare @name char(10) select @name='yuyong' print(@name) go print(@name) go --例如这个例子,第二个print将会
Python上机练习题
adim__的博客
10-23 1万+
1、 编写一个程序，体术输入整数X,然后计算从1开始，连续X个整数之和。提示reduce()函数。 from functools import reduce num = input("请输入整数x：") num = int(num) sum = reduce(lambda x, y: x+y, range(1, num)) print("从1至X的和为：%d" %(sum)) 2、已知两个列表...
MYSQL基础上机练习题（一） 数据库、表、字段的创建、修改、删除
热门推荐
CheyenneLam的博客
12-21 1万+
在这里，从SQL SERVER 2008的一本书中模仿了其中员工管理数据库的数据，同时随机增加了数据项，同时添加一些自己觉得比较重要的知识点，从基础做起，把日常能用到的数据库语句用一遍，让有需要的小白可以多练练手，以免纸上谈兵。
教学思路SQL之入门习题《学员成绩》 一、建表
weixin_33725270的博客
05-16 164
习题一学员成绩： 1.创建一个名为学员成绩的数据库， 主要数据文件初始大小为10MB，最大空间为30MB，文件增长幅度为5MB，日志文件初始大小为5MB，最大为20MB，文件增长幅度为3MB，请自行设定文件的保存路径。 2.创建学生信息表（Student）包含：学生编号、学生姓名、性别、年龄、地区、联系电话、入学日期。 3.创建课程信...
MySchool数据
qq_36074064的博客
11-22 1194
USE [MySchool] GO /****** Object:  Table [dbo].[Grade]    Script Date: 2016/11/21 15:19:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Grade]( [GradeId] [int]
python上机练习题
最新发布
09-16
当然，我可以为您提供一些 Python 的上机练习题。以下是一个简单的例子： 题目：编写一个 Python 程序，用于计算并输出斐波那契数列的前 n 个数字。 提示： - 斐波那契数列是一个由 0 和 1 开始，后续每个数字都是...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值