表名：ZL_Paper_Questions












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2QuestionTitlenvarchar500   是 大题标题
3PaperIDint40   是 试卷ID
4OrderByint40   是 排序条件
5QuestionTypeint40   是 题型
6Subtitlenvarchar5000   是 副标题
7Coursefloat80   是 每小题分数
8QuesNumint40   是 包含题数
9Remarknvarchar5000   是 答题说明
10QuestIDsnvarchar5000   是 试题ID(多个以逗号隔开)
11CreateTimedatetime83   是 创建时间
12AddUserint40   是 添加用户

简要说明：

系统试题表

GO
CREATE TABLE [dbo].[ZL_Paper_Questions](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuestionTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PaperID] [int] NULL,
[OrderBy] [int] NULL,
[QuestionType] [int] NULL,
[Subtitle] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[Course] [float] NULL,
[QuesNum] [int] NULL,
[Remark] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[QuestIDs] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[CreateTime] [datetime] NULL,
[AddUser] [int] NULL
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'大题标题' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'QuestionTitle'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试卷ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'PaperID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'题型' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'QuestionType'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'副标题' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'Subtitle'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'每小题分数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'Course'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'包含题数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'QuesNum'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'答题说明' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'Remark'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试题ID(多个以逗号隔开)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'QuestIDs'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'CreateTime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加用户' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Paper_Questions', @level2type=N'COLUMN',@level2name=N'AddUser'

SET IDENTITY_INSERT [ZL_Paper_Questions] ON
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 1,'填空题',2,1,5,2,5,'2010/09/20 18:10:09',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 2,'单选题',2,2,1,'请选择正确答案',2,5,'sdfds','2010/09/20 18:11:37',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 3,'多选题',2,3,2,'从选项中找出与下面句子中的括号单词的相近的单词意思',2,5,'2010/09/20 18:12:40',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 4,'判断题',2,4,4,'sdfdsf',5,3,'从选项中 找出与括号相近的词汇','2010/09/20 18:13:17',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 5,'应用题',2,5,3,10,1,'2010/09/20 18:17:03',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 9,'ssas',5,1,1,'as',0,5,'as','2010/09/24 18:17:29',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 10,'单选题',1,1,1,'单选副标题',5,5,'单选答题说明','2010/09/25 10:19:14',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 11,'多选题',1,2,2,'多选副标题',5,3,'答题说明','2010/09/25 11:44:00',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 12,'主观题',1,3,3,'应用题副标题',2,2,'答题说明','2011/07/07 11:29:36',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 13,'基础知识',0,1,3,'基础知识',5,5,'基础知识','2011/07/07 14:32:46',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 14,'阅读理解',9,1,3,'阅读理解',5,3,'阅读','2011/07/07 14:33:44',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 15,'单选',9,2,1,'撒旦gas',2,2,'2011/07/07 14:41:31',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 16,'判断题',9,3,4,'风中日月',5,3,'观察公司股东及化工','2011/07/07 14:53:43',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 31,'单选题',4,1,1,3,1,'2011/07/19 17:45:27',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 18,'选择题',13,1,1,2,1,'无','2011/07/07 15:35:52',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 19,'判断题',13,2,4,2,1,'无','2011/07/07 15:36:30',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 20,'应用题',13,3,3,10,1,'意思差不多就行','2011/07/07 15:37:18',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 21,'改革的改革',13,4,2,2,1,'高高挂','2011/07/07 15:46:41',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 29,'计算机判断题',3,2,4,'计算机基础判断',2,2,'2011/07/18 10:29:25',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 23,'11111',14,1,1,'1111',10,2,'11111','2011/07/07 19:49:56',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Subtitle],[Course],[QuesNum],[Remark],[CreateTime],[AddUser]) VALUES ( 24,'222222',14,2,2,'22222',5,2,'222','2011/07/07 19:50:13',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 25,'单项选择题',15,1,1,5,2,'2011/07/14 11:28:17',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 26,'多项选择题',15,2,2,5,2,'2011/07/14 11:28:39',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 27,'实际应用题',15,3,3,10,2,'2011/07/14 11:29:03',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 28,'填空题',3,1,5,16,2,'2011/07/14 15:10:35',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 30,'大题',9,4,5,20,2,'2011/07/18 22:15:09',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 32,'多选题',4,2,2,5,2,'2011/07/19 17:45:55',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 33,'判断题',4,3,4,5,2,'2011/07/19 17:46:13',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 34,'填空题',4,4,5,5,1,'2011/07/19 17:46:35',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 35,'主观题',4,5,3,10,1,'2011/07/19 17:46:50',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 36,'单选',17,1,1,5,2,'2011/07/20 21:00:36',1)
INSERT [ZL_Paper_Questions] ([ID],[QuestionTitle],[PaperID],[OrderBy],[QuestionType],[Course],[QuesNum],[CreateTime],[AddUser]) VALUES ( 37,'多选题',17,2,2,5,2,'2011/07/20 21:00:53',1)
SET IDENTITY_INSERT [ZL_Paper_Questions] OFF

--注意：将清空全表数据

detele from ZL_Paper_Questions

--注意：将删除整个表

drop table ZL_Paper_Questions

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Paper_Questions