GO
CREATE TABLE [dbo].[ZL_Questions](
[p_id] [int] IDENTITY(1,1) NOT NULL,
[p_title] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[p_Difficulty] [decimal](18, 2) NULL,
[p_Class] [int] NULL,
[p_Views] [int] NULL,
[p_Inputer] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[p_Type] [int] NULL,
[p_Knowledge] [int] NOT NULL,
[p_Answer] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[p_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[p_CreateTime] [datetime] NULL CONSTRAINT [DF_ZL_Questions_p_CreateTime] DEFAULT (getdate()),
[Paper_Id] [int] NOT NULL,
[p_Order] [int] NULL CONSTRAINT [DF_ZL_Questions_p_Order] DEFAULT (0)
) ON [PRIMARY] TEXTIMAGE_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_Questions', @level2type=N'COLUMN',@level2name=N'p_title'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'难度' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Difficulty'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'分类' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Class'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'使用次数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Views'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'作者' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Inputer'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'题型' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Type'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'知识点' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Knowledge'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'答案' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Answer'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试题内容' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Content'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_CreateTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'所属试卷ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'Paper_Id'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试题排序' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions', @level2type=N'COLUMN',@level2name=N'p_Order'
GO
SET IDENTITY_INSERT [ZL_Questions] ON
INSERT [ZL_Questions] ( [p_id] , [p_title] , [p_Difficulty] , [p_Class] , [p_Views] , [p_Inputer] , [p_Type] , [p_Knowledge] , [p_Answer] ,
[p_Content] , [p_CreateTime] , [Paper_Id] ) VALUES ( 1 , 'sdfsf' , 1 , 1 , 1 , 'admin' , 1 , 0 , '' , 'sdfdsfsdsfdsfsd' ,
'2010-04-17 00:00:00.000' , 0 )
INSERT [ZL_Questions] ( [p_id] , [p_title] , [p_Difficulty] , [p_Class] , [p_Views] , [p_Inputer] , [p_Type] , [p_Knowledge] , [p_Answer] ,
[p_Content] , [p_CreateTime] , [Paper_Id] ) VALUES ( 2 , '此次抽查' , 2 , 2 , 1 , 'admin' , 2 , 0 , '' , '梵蒂冈但是' ,
'2010-04-17 00:00:00.000' , 0 )
INSERT [ZL_Questions] ( [p_id] , [p_title] , [p_Difficulty] , [p_Class] , [p_Views] , [p_Inputer] , [p_Type] , [p_Knowledge] , [p_Answer] ,
[p_Content] , [p_CreateTime] , [Paper_Id] ) VALUES ( 3 , '第一章 声现象' , 1 , 1 , 1 , 'admin' , 3 , 0 , '<div _extended="true" class="daan"
id="daan-62928">
<p>
<span>I=U/R </span><span>电阻一定时，电流与是压成正比</span></p>
<p>
<span>U=IR </span><span>电压一定时，电流与电阻成反比</span></p>
<p>
<span>R=U/I </span><span>电阻等于电压和电流的比值</span></p>
</div>' , '欧姆定律揭示了I、U、R三个物理量之间的规律，并可以写出三个物理公式。请你分别写出三个公式并说出每个公式所表示的意义？' ,
'2010-04-17 00:00:00.000' , 0 )
INSERT [ZL_Questions] ( [p_id] , [p_title] , [p_Difficulty] , [p_Class] , [p_Views] , [p_Inputer] , [p_Type] , [p_Knowledge] , [p_Answer] ,
[p_Content] , [p_CreateTime] , [Paper_Id] ) VALUES ( 4 , '初二物理第二学期期末检测 ' , 4 , 1 , 1 , 'admin' , 3 , 2 , '<div _extended="true"
class="daan" id="daan-62927">
<p>
<span>用电器和电线是串联的，电流相同，但用电器的电阻比电线的电阻要大很多，据</span><span>P=I<sup>2</sup>R</span></p>
<p>
<span> </span><span>电阻越大，发热就越厉害。</span></p>
</div>' , '莉莉学习了《电功率》一章的知识后，回家仔细观察了家里的电水壶、电饭锅等较大功率的用电器在工作时的情况是：电水壶、电饭锅都很热而连接
它们的电线却不热。请你和莉莉共同探究这个问题并把你的想法写在下面： ' , '2010-04-17 00:00:00.000' , 0 )
INSERT [ZL_Questions] ( [p_id] , [p_title] , [p_Difficulty] , [p_Class] , [p_Views] , [p_Inputer] , [p_Type] , [p_Knowledge] , [p_Answer] ,
[p_Content] , [p_CreateTime] , [Paper_Id] ) VALUES ( 5 , '第一章 力' , 2 , 2 , 1 , 'admin' , 3 , 1 , '<div _extended="true" class="daan"
id="daan-218816">
<p>
<span>（</span><span>1</span><span>）由</span><span><sub><img height="44"
src="http://gzwl.cooco.net.cn/files/down/test/2010/04/14/17/2010041417061723933126.files/image033.gif" width="279" /></sub></span><span>得
</span></p>
<p>
<span><sub><img height="44"
src="http://gzwl.cooco.net.cn/files/down/test/2010/04/14/17/2010041417061723933126.files/image034.gif" width="352" /></sub>
</span><span>（</span><span>2</span><span>）当</span><span>ab</span><span>棒达到最大速度时有</span><span><sub><img height="44"
src="http://gzwl.cooco.net.cn/files/down/test/2010/04/14/17/2010041417061723933126.files/image035.gif" width="125" /></sub></span><span>所以
：</span></p>
<p>
<span><sub><img height="41"
src="http://gzwl.cooco.net.cn/files/down/test/2010/04/14/17/2010041417061723933126.files/image036.gif" width="253" /></sub></span></p>
<p>
<span>当</span><span>ab</span><span>棒达到最大速度后，撤去外力</span><span>F</span><span>，此后物体的动能全用来克服安培力作功
，所以感应电流产生的热量为：</span><span><sub><img height="41"
src="http://gzwl.cooco.net.cn/files/down/test/2010/04/14/17/2010041417061723933126.files/image037.gif" width="215" /></sub></span></p>
<p>
</p>
</div>' , '水平放置的平行金属框架L=0.2m,质量为0.1kg的金属棒ab放在框架上，并且与框架的两个边垂直。整个装置放于方向竖直向下、B=0.5T的匀强磁场中
，如图所示。金属棒ab在F=2N的水平向右的恒力作用下由静止开始运动。电路中除R=0.05外，其他电阻、摩擦阻力均不考虑。求：① ab速度是5m/s时，棒的加速
度是多大？
② 当ab棒达到最大速度后，撤去外力F，此后感应电流还能产生多少热量？' , '2010-04-17 00:00:00.000' , 0 )
SET IDENTITY_INSERT [ZL_Questions] OFF
