Csharp学校信息管理系统

USE [E:\ASP.NET 2.0数据库开发经典案例分析\源代码\第2章 学校教务管理系统\APP_DATA\MYSCHOOLDB.MDF] GO /****** 对象: Table [dbo].[课程安排] 脚本日期: 07/23/2007 18:01:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[课程安排]( [自动编号] [int] IDENTITY(1,1) NOT NULL, [班级名称] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [学期名称] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M4] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M5] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M6] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M7] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [M8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T4] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T5] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T6] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T7] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [T8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W4] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W5] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W6] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W7] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [W8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H4] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H5] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H6] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H7] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [H8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F4] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F5] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F6] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F7] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [F8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_课程安排] PRIMARY KEY CLUSTERED ( [自动编号] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第一节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M1' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第二节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M2' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第三节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M3' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第四节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M4' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第五节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M5' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'表示星期一第六节课' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'课程安排', @level2type=N'COLUMN', @level2name=N'M6' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @va�