菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•<= /span>= 一、实验类型 <= /div>

–= 验证性

•<= /span>= 二、实验目的

–= 了解数据库常用对象= 1450;组成；

–= 熟悉SQL= = 的基本概念和特点；= 3;

–<= /span>= 熟练掌握T-SQL = 语句中的数据定义的= 0351;用方法；

–= 熟悉在SQL Server= 2005= 中创建及编辑数据库= 5307;

–= 熟练掌握SQL= = 的数据定义子句的使= 9992;方法。

<= span style=3D'font-family:SimSun;mso-fareast-font-family:SimSun;mso-special-for= mat: lastCR;display:none'>

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0003.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•<= /span>= 三、实验环境

–= 已安装SQL Server= 2005= 计算机；

–= 具有局域网网络环境= 5292;有固定ip<= span style=3D'font-family:SimSun;mso-fareast-font-family:SimSun;font-size:71%'>= 地址；

•<= /span>= 四、实验学时

–2= 学时

•<= /span>= 五、实验要求

–<= /span>= 熟练使用Management= Stuio= 界面方式创建及编辑= 5968;据库；

–= 熟练使用T-SQL = 语句创建及编辑数据= 4211;；

–= 完成实验报告。

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0005.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•五、实&= #39564;准备知识（也可参 = 771;SQL Ser= ver= 联机丛书）

•数据库= 456;关属性

–逻辑名= 216;：数据文件和日志文= ;件名称

–文件类= 411;：数据文件及日志文= ;件

–文件组A= 306;各个数据文件所属的= ;文件组名称

–初始大= 567;：文件的最原始大小= ;

–自动增&= 271;：文件按指定的大小= ;增长，也可限制到最&#= 22823;容量。

–路径：= 384;放文件的物理目录

–文件名A= 306;显示数据文件和日志= ;文件的物理名称

•默认数= 454;库属性

–主数据= 991;件为xx.mdf = ，日志文件为xx_log.ldf= = ；

–只有一= 010;文件组Primary= ；

–主数据= 991;件初始大小为3MB= = ，增量为1MB= = ；

–日志文= 214;初始大小为1MB= = ，增量为10%= = ；

–= 主数据文件和日志文= 0214;都存放在C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA目录下，文件&= #20998;别为xx.mdf 和xx_log.ldf = 。

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0008.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•<= /span>= 使用界面创建数据库= 7493;骤

–<= /span>【SQL Server Management S= tudio】→【对&= #35937;资源管理器】→【ă= 68;据库】→【新建数据&= #24211;】→= 设置数据库相关属性= 5288;名称、大小、位置ᦀ= 9;

•<= /span>= 启动SQL Server= 2005= 查询分析器

–【SQL Server Management S= tudio】→【新&= #24314;查询】

•<= /span>= 命令方式下创建数据= 4211;

–CREATE DAT= ABASE database_name /*= 指定数据库名*/

–[ON = 子句 ] <= span style=3D'mso-tab-count:1;width:2.27%'> = ; &n= bsp; = ; /*= 指定数据库文件和文= 0214;组属性

–[LOG ON 子句 ] = ; &n= bsp; = ; /*指定日志文件属= 4615;*/

•<= /span>= 命令方式修改数据库= 3;

–Alter data= base database_name

–{add file <filespec>[,…n] [to filegroup filegroupname]

–|add log f= ile <filespec>[,…n]

–|remove fi= le logical_file_name [with delete]

–|modify fi= le <filespec>

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0006.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•七、实&= #39564;内容及步骤

•1、假设SQL Server= = 服务已启动，并以Administra= tor= 身份登录计算机= （文件名称自定）；= 5831;分别使用Management= = 界面方式和T-SQL= 语句= = 实现以下操作： =

–= 要求在本地磁盘D= 创建一个学生-= 课程数据库（名称为student= ），只有一= 个数据文件和日志文= 0214;，文件名称分别为stu= = 和stu_log= ，物理名称为stu_data.m= df = 和stu_log.ld= f= ，初始大小都为3MB= = ，增长方式分别为10%= = 和1MB= = ，数据文件最大为500MB= ，日志文件大小不受= 8480;制。

–创建一个Company= 数据库，该数据库的= 0027;数据文件逻辑名称ߒ= 6;Company_da= ta= ，物理文件为Company.md= f= ，初始大小为10MB= ，最大尺= 寸为无限大，增长速= 4230;为10%= = ；数据库的日志文件= 6923;辑名称为Company_lo= g= ，物理文件名为Company.ld= f= ，初始大小为1MB= = ，最大尺寸= 为50MB= ，增长速度为1MB= = 。

–创建数据库DB<= span style=3D'font-family:SimSun;mso-fareast-font-family:SimSun;font-size:64%'>= ，具有2= 个数据文件，文件逻= 6753;名分别为DB_data1= 和DB_data2= ，文件初始大小均为5MB= = ，最大为100MB= ，按10%= = 增长；只有= = 一个日志文件，初始= 2823;小为3MB= = ，按10%= = 增长；所有文件都存= 0648;在D= 盘文= 件夹ceshi= 中。

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0009.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

–= 在数据库student= 中增加数据文件db2= = ，初始大小为10MB= ，最大大= 小为50 MB= ，按10%= = 增长；

–在数据库student= 中添加日志文件，保= 3384;在D= 盘中，初始大小为1MB= = ，最大无限制，增长= 6041;式按照1MB= = 增长；

–= 修改数据库student= 主数据文件的大小，= 3558;主数据文件的初始࣪= 3;小= 修改为10Mb= ，增长方式为20%= = ；

–修改数据库student= 辅助数据文件初始大= 3567;为3MB= = ，最大为100MB= ，按照10%= = 增长，名称为db;

–删除数= 454;库student= 辅助数据文件和第二= 0010;日志文件；

–删除数= 454;库company= 和DB<= span style=3D'font-family:SimSun;mso-fareast-font-family:SimSun;font-size:71%'>= 。

•2、将数= 454;库student= 的所有物理文件移动= 1040;‘D:\xxx‘,= 并且= 保证逻辑数据库不受= 4433;响，请详细描述解ࠫ= 5;办法

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/slide0007.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛

•八、讨论= 出现问题及解决办法&= #13;

–如某些操= 0316;无法执行，如何解ࠫ= 5;？

•

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/master03_stylesheet.css Content-Transfer-Encoding: base64 Content-Type: text/css Ym9keQ0KCXt3aWR0aDo1MzRweDsNCgloZWlnaHQ6NDAwcHg7fQ0KLlRCDQoJe21zby1zcGVjaWFs LWZvcm1hdDpub2J1bGxldFwyMDIyO30NCi5UDQoJe3RleHQtYWxpZ246Y2VudGVyOw0KCWZvbnQt ZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhh bnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCWNvbG9yOmJsYWNrOw0KCW1zby1jb2xvci1pbmRleDoz Ow0KCWZvbnQtc2l6ZToyMDklOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVy ZmxvdzoxO30NCi5CQg0KCXttc28tc3BlY2lhbC1mb3JtYXQ6YnVsbGV0XDIwMjI7fQ0KLkINCgl7 dGV4dC1hbGlnbjpsZWZ0Ow0KCWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250 LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCWNvbG9yOmJs YWNrOw0KCW1zby1jb2xvci1pbmRleDoxOw0KCWZvbnQtc2l6ZToxNTIlOw0KCW1zby1jaGFyLXdy YXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5CMUINCgl7bXNvLXNwZWNpYWwtZm9y bWF0OmJ1bGxldFwyMDEzO30NCi5CMQ0KCXt0ZXh0LWFsaWduOmxlZnQ7DQoJZm9udC1mYW1pbHk6 U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9u dC1mYW1pbHk6QXJpYWw7DQoJY29sb3I6YmxhY2s7DQoJbXNvLWNvbG9yLWluZGV4OjE7DQoJZm9u dC1zaXplOjEzMyU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7 fQ0KLkIyQg0KCXttc28tc3BlY2lhbC1mb3JtYXQ6YnVsbGV0XDIwMjI7fQ0KLkIyDQoJe3RleHQt YWxpZ246bGVmdDsNCglmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1p bHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgljb2xvcjpibGFjazsN Cgltc28tY29sb3ItaW5kZXg6MTsNCglmb250LXNpemU6MTE0JTsNCgltc28tY2hhci13cmFwOjE7 DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouQjNCDQoJe21zby1zcGVjaWFsLWZvcm1hdDpi dWxsZXRcMjAxMzt9DQouQjMNCgl7dGV4dC1hbGlnbjpsZWZ0Ow0KCWZvbnQtZmFtaWx5OlNpbVN1 bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFt aWx5OkFyaWFsOw0KCWNvbG9yOmJsYWNrOw0KCW1zby1jb2xvci1pbmRleDoxOw0KCWZvbnQtc2l6 ZTo5NSU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkI0 Qg0KCXttc28tc3BlY2lhbC1mb3JtYXQ6YnVsbGV0XDAwQkI7fQ0KLkI0DQoJe3RleHQtYWxpZ246 bGVmdDsNCglmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2lt U3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgljb2xvcjpibGFjazsNCgltc28t Y29sb3ItaW5kZXg6MTsNCglmb250LXNpemU6OTUlOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28t a2luc29rdS1vdmVyZmxvdzoxO30NCi5ODQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFy ZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0K CW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5OMQ0KCXtmb250 LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1o YW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Ut b3ZlcmZsb3c6MTt9DQouTjINCgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZv bnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJbXNvLWNo YXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLk4zDQoJe2ZvbnQtZmFtaWx5 OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZv bnQtZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxv dzoxO30NCi5ONA0KCXtmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1p bHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFw OjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouT0INCgl7bXNvLXNwZWNpYWwtZm9ybWF0 Om5vYnVsbGV0XDIwMjI7fQ0KLk8NCgl7dGV4dC1hbGlnbjpsZWZ0Ow0KCWZvbnQtZmFtaWx5OlNp bVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQt ZmFtaWx5OkFyaWFsOw0KCWNvbG9yOmJsYWNrOw0KCW1zby1jb2xvci1pbmRleDoxOw0KCWZvbnQt c2l6ZTo4NSU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0K Lk8xDQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1T dW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFyLXdyYXA6MTsNCglt c28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5PMg0KCXtmb250LWZhbWlseTpTaW1TdW47DQoJbXNv LWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlh bDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouTzMNCgl7 Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCglt c28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5z b2t1LW92ZXJmbG93OjE7fQ0KLk80DQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFz dC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1z by1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5DQkINCgl7bXNvLXNw ZWNpYWwtZm9ybWF0Om5vYnVsbGV0XDIwMjI7fQ0KLkNCDQoJe3RleHQtYWxpZ246Y2VudGVyOw0K CWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJ bXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCWNvbG9yOmJsYWNrOw0KCW1zby1jb2xvci1p bmRleDoxOw0KCWZvbnQtc2l6ZToxNTIlOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29r dS1vdmVyZmxvdzoxO30NCi5DQjENCgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0 LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJbXNv LWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkNCMg0KCXtmb250LWZh bWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5z aS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3Zl cmZsb3c6MTt9DQouQ0IzDQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250 LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFy LXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5DQjQNCgl7Zm9udC1mYW1pbHk6 U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9u dC1mYW1pbHk6QXJpYWw7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93 OjE7fQ0KLkNUQg0KCXttc28tc3BlY2lhbC1mb3JtYXQ6bm9idWxsZXRcMjAyMjt9DQouQ1QNCgl7 dGV4dC1hbGlnbjpjZW50ZXI7DQoJZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZv bnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJY29sb3I6 YmxhY2s7DQoJbXNvLWNvbG9yLWluZGV4OjM7DQoJZm9udC1zaXplOjIwOSU7DQoJbXNvLWNoYXIt d3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkhCDQoJe2ZvbnQtZmFtaWx5OlNp bVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQt ZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzox O30NCi5IQjENCgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZvbnQtZmFtaWx5 OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJbXNvLWNoYXItd3JhcDox Ow0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkhCMg0KCXtmb250LWZhbWlseTpTaW1TdW47 DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWls eTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQou SEIzDQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1T dW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFyLXdyYXA6MTsNCglt c28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5IQjQNCgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1z by1mYXJlYXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJp YWw7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlFCDQoJ e2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1mb250LWZhbWlseTpTaW1TdW47DQoJ bXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2lu c29rdS1vdmVyZmxvdzoxO30NCi5RQjENCgl7Zm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1mYXJl YXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2ktZm9udC1mYW1pbHk6QXJpYWw7DQoJ bXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlFCMg0KCXtmb250 LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1o YW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Ut b3ZlcmZsb3c6MTt9DQouUUIzDQoJe2ZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28tZmFyZWFzdC1m b250LWZhbWlseTpTaW1TdW47DQoJbXNvLWhhbnNpLWZvbnQtZmFtaWx5OkFyaWFsOw0KCW1zby1j aGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5RQjQNCgl7Zm9udC1mYW1p bHk6U2ltU3VuOw0KCW1zby1mYXJlYXN0LWZvbnQtZmFtaWx5OlNpbVN1bjsNCgltc28taGFuc2kt Zm9udC1mYW1pbHk6QXJpYWw7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJm bG93OjE7fQ0KLlRibA0KCXtmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1m YW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13 cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouVGJsMQ0KCXtmb250LWZhbWlseTpT aW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250 LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6 MTt9DQouVGJsMg0KCXtmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1p bHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFw OjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouVGJsMw0KCXtmb250LWZhbWlseTpTaW1T dW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZh bWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9 DQouVGJsNA0KCXtmb250LWZhbWlseTpTaW1TdW47DQoJbXNvLWZhcmVhc3QtZm9udC1mYW1pbHk6 U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCgltc28tY2hhci13cmFwOjE7 DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouZGVmYXVsdEINCgl7bXNvLXNwZWNpYWwtZm9y bWF0Om5vYnVsbGV0XDIwMjI7fQ0KLmRlZmF1bHQNCgl7dGV4dC1hbGlnbjpsZWZ0Ow0KCWZvbnQt ZmFtaWx5OlNpbVN1bjsNCgltc28tYXNjaWktZm9udC1mYW1pbHk6QXJpYWw7DQoJbXNvLWZhcmVh c3QtZm9udC1mYW1pbHk6U2ltU3VuOw0KCW1zby1oYW5zaS1mb250LWZhbWlseTpBcmlhbDsNCglm b250LXdlaWdodDpub3JtYWw7DQoJZm9udC1zdHlsZTpub3JtYWw7DQoJdGV4dC1kZWNvcmF0aW9u Om5vbmU7DQoJdGV4dC1zaGFkb3c6bm9uZTsNCgl0ZXh0LWVmZmVjdDpub25lOw0KCW1zby1mYXJl YXN0LWhpbnQ6bm87DQoJbGF5b3V0LWZsb3c6aG9yaXpvbnRhbDsNCgljb2xvcjpibGFjazsNCglt c28tY29sb3ItaW5kZXg6MTsNCglmb250LXNpemU6ODUlOw0KCW1zby10ZXh0LXJhaXNlOjAlOw0K CW1zby1saW5lLXNwYWNpbmc6IjEwMCAwIDAiOw0KCW1zby1tYXJnaW4tbGVmdC1hbHQ6MDsNCglt c28tdGV4dC1pbmRlbnQtYWx0OjA7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92 ZXJmbG93OjE7DQoJZGlyZWN0aW9uOmx0cjsNCgltc28td29yZC13cmFwOjE7DQoJbXNvLXZlcnRp Y2FsLWFsaWduLXNwZWNpYWw6YmFzZWxpbmU7DQoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6WkgtQ047 DQoJbXNvLWFuc2ktbGFuZ3VhZ2U6RU4tVVM7fQ0KYTpsaW5rDQoJe2NvbG9yOiMwMDk5OTkgIWlt cG9ydGFudDt9DQphOmFjdGl2ZQ0KCXtjb2xvcjojMzMzMzk5ICFpbXBvcnRhbnQ7fQ0KYTp2aXNp dGVkDQoJe2NvbG9yOiM5OUNDMDAgIWltcG9ydGFudDt9DQp= ------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/script.js Content-Transfer-Encoding: quoted-printable Content-Type: application/javascript; charset="us-ascii" function LoadSld() { var sld=3DGetObj("SlideObj") if( !g_supportsPPTHTML ) { =09 sld.style.visibility=3D"visible" return } if( MakeNotesVis() ) return runAnimations =3D _InitAnimations(); =09 if( IsWin("PPTSld") ) parent.SldUpdated(GetSldId()) g_origSz=3DparseInt(SlideObj.style.fontSize) g_origH=3Dsld.style.posHeight g_origW=3Dsld.style.posWidth g_scaleHyperlinks=3D(document.all.tags("AREA").length>0) if( g_scaleHyperlinks ) InitHLinkArray() if( g_scaleInFrame||(IsWin("PPTSld") && parent.IsFullScrMode() ) ) document.body.scroll=3D"no" _RSW() if( IsWin("PPTSld") && parent.IsFullScrMode() ) FullScrInit(); =09 MakeSldVis(); ChkAutoAdv() if( runAnimations ) { if( document.all("NSPlay") ) document.all("NSPlay").autoStart =3D false; if( sld.filters && sld.filters.revealtrans ) setTimeout( "document.body.start()", sld.filters.revealtrans.duration * = 1000 ); else document.body.start(); } } function MakeSldVis()=20 { var fTrans=3Dg_showAnimation && SldHasTrans() if( fTrans )=09 { if( g_bgSound ) { idx=3Dg_bgSound.indexOf(","); pptSound.src=3Dg_bgSound.substr( 0, idx ); pptSound.loop=3D -(parseInt(g_bgSound.substr(idx+1))); } SlideObj.filters.revealtrans.Apply()=09 } SlideObj.style.visibility=3D"visible" if( fTrans ) SlideObj.filters.revealtrans.Play() } function MakeNotesVis()=20 { if( !IsNts() ) return false=20 SlideObj.style.display=3D"none" nObj =3D document.all.item("NotesObj") parent.SetHasNts(0) if( nObj ) {=20 nObj.style.display=3D"" parent.SetHasNts(1) } return 1 } function ChkAutoAdv() { if(SldHasTrans()) SlideObj.onfilterchange=3DAutoAdv else AutoAdv() } function AutoAdv() { if(!IsWin("PPTSld") || !gUseSldTimings )return var sld=3DGetCurSld() if( (sld.mAdvDelay>0) && !parent.IsFramesMode() ) setTimeout("parent.GoToNextSld()",sld.mAdvDelay) } function GetObj(id) { if(g_supportsPPTHTML) return document.all(id); else return document.getElementById(id); } function SldHasTrans() { return SlideObj.style.filter !=3D ""; } function GetSldId() { return sId=3Dlocation.href.substring(location.href.la= stIndexOf('/')+1) } function HideMenu() { if( frames["PPTSld"] && PPTSld.document.all.item("ctx= tmenu") && PPTSld.ctxtmenu.style.display!=3D"none" ) { PPTSld.ctxtmenu.styl= e.display=3D'none'; return true } return false } function IsWin( name ) { return window.name =3D=3D name } function IsNts() { return IsWin("PPTNts") } function IsSldOrNts() { return( IsWin("PPTSld")||IsWin("PPTNts") ) } function SupportsPPTAnimation() { return( navigator.platform =3D=3D "Win32"= && navigator.appVersion.indexOf("Windows")>0 ) } function SupportsPPTHTML() { var appVer=3Dnavigator.appVersion, msie=3DappVer.indexOf("MSIE "), ver=3D0 if( msie >=3D 0 ) ver=3DparseFloat( appVer.substring( msie+5, appVer.indexOf(";",msie) ) ) else ver=3DparseInt(appVer) return( ver >=3D 4 && msie >=3D 0 ) } function _RSW() { if( !g_supportsPPTHTML || IsNts() || ( !g_scaleInFrame && (!IsWin("PPTSld") || !parent.IsFullScrMode()) ) ) return var padding=3D0; if( IsWin("PPTSld") && parent.IsFramesMode() ) padding=3D6 cltWidth=3Ddocument.body.clientWidth-padding cltHeight=3Ddocument.body.clientHeight-padding factor=3D(1.0*cltWidth)/g_origW if( cltHeight < g_origH*factor ) factor=3D(1.0*cltHeight)/g_origH newSize =3D g_origSz * factor if( newSize < 1 ) newSize=3D1 s=3DSlideObj.style s.fontSize=3DnewSize+"px" s.posWidth=3Dg_origW*factor s.posHeight=3Dg_origH*factor s.posLeft=3D(cltWidth-s.posWidth+padding)/2 s.posTop=3D(cltHeight-s.posHeight+padding)/2 if( g_scaleHyperlinks ) ScaleHyperlinks( factor ) } function _InitAnimations() { animRuntimeInstalled =3D ''+document.body.localTime !=3D 'undefined'; isFullScreen =3D (window.name =3D=3D "PPTSld") && !parent.IsFramesMode(); g_animUseRuntime =3D g_showAnimation && animRuntimeInstalled && !(isFullSc= reen && parent.IsSldVisited()); if( g_animUseRuntime ) { collSeq =3D document.all.tags("seq"); if( collSeq !=3D null ) { for(ii=3D0;ii numSlds ) gSldJumpIdx =3D numSlds; if ( gSldJumpIdx >=3D 0 ) { if ( gSldJumpIdx =3D=3D 0 ) gSldJumpIdx =3D 1; var jumpTo =3D parseInt(gSldJumpIdx); gSldJump =3D 0; gSldJumpIdx =3D ""; win.GoToSld( parent.GetSldList().mList[jumpTo-1].mSldHref ) } } } function _KDH() { if( event.keyCode =3D=3D 8 ) { event.returnValue =3D 0; parent.GoToPrevSld(); } } function DocumentOnClick() { if( IsNts() || parent.HideMenu() ) return; if( ( g_allowAdvOnClick && !parent.IsFramesMode() ) || (event && (event.keyCode=3D=3D32) ) ) parent.GoToNextSld(); } var g_supportsPPTHTML =3D SupportsPPTHTML(), g_scaleInFrame =3D 1, gId=3D""= , g_bgSound=3D"", g_scaleHyperlinks =3D false, g_allowAdvOnClick =3D 1, g_showInBrowser = =3D 0, gLoopCont =3D 0, gUseSldTimings =3D 1; var g_showAnimation =3D g_supportsPPTHTML && SupportsPPTAnimation() && ( (w= indow.name=3D=3D"PPTSld" && !parent.IsFramesMode()) || g_showInBrowser );va= r g_animManager =3D null; var g_animUseRuntime =3D false; var g_animItemsToHide, g_animInteractiveItems, g_animSlideTime; var g_animMainSequence =3D null; var ENDSHOW_MESG=3D"放映结束，单击= ;鼠标退出。", SCREEN_MODE=3D"Frames", gIsEndS= how=3D0, NUM_VIS_SLDS=3D8, SCRIPT_HREF=3D"script.js", FULLSCR_HREF=3D"fulls= creen.htm"; var gCurSld =3D gPrevSld =3D 1, g_offset =3D 0, gNtsOpen =3D gHasNts =3D gO= tlTxtExp =3D 0, gHasNarration =3D 0, gOtlOpen =3D true window.gPPTHTML=3DSupportsPPTHTML() var gMainDoc=3Dnew Array(new hrefList("slide0001.htm",1,-1,1),new hrefList(= "slide0002.htm",1,-1,1),new hrefList("slide0003.htm",1,-1,1),new hrefList("= slide0005.htm",1,-1,1),new hrefList("slide0008.htm",1,-1,1),new hrefList("s= lide0006.htm",1,-1,1),new hrefList("slide0009.htm",1,-1,1),new hrefList("sl= ide0007.htm",1,-1,1)); /********************************************* Frameset functions These functions control slide navigation and state of the frameset. **********************************************/ function FullScrInit() { g_allowAdvOnClick =3D GetCurSld().mAdvOnClk document.body.style.backgroundColor=3D"black" document.oncontextmenu=3Dparent._CM; document.onkeydown =3D _KDH; document.ondragstart=3DCancel document.onselectstart=3DCancel self.focus() } function Redirect( frmId ) {=09 var str=3Ddocument.location.hash,idx=3Dstr.indexOf('#'), sId=3DGetSldId() if(idx>=3D0) str=3Dstr.substr(1); if( window.name !=3D frmId && ( sId !=3D str) ) { obj =3D GetObj("Main-File") window.location.href=3Dobj.href+"#"+sId return 1 } return 0 } var MHTMLPrefix =3D CalculateMHTMLPrefix();=20 function CalculateMHTMLPrefix() { if ( document.location.protocol =3D=3D 'mhtml:') {=20 href=3Dnew String(document.location.href)=20 Start=3Dhref.indexOf('!')+1=20 End=3Dhref.lastIndexOf('/')+1=20 if (End < Start)=20 return href.substring(0, Start)=20 else=20 return href.substring(0, End)=20 } return ''; } function GetTags(base,tag) { if(g_supportsPPTHTML) return base.all.tags(tag); else return base.getElementsByTagName(tag); } function UpdNtsPane(){ if(frames["PPTNts"]) PPTNts.location.replace( MHTMLP= refix+GetHrefObj( gCurSld ).mNtsHref ) } function UpdNavPane( sldIndex ){ if(gNavLoaded) PPTNav.UpdNav() } function UpdOtNavPane(){ if(gOtlNavLoaded) PPTOtlNav.UpdOtlNav() } function UpdOtlPane(){ if(gOtlLoaded) PPTOtl.UpdOtl() } function SetHasNts( fVal ) { if( gHasNts !=3D fVal ) { gHasNts=3DfVal UpdNavPane() } } function ToggleOtlText() { gOtlTxtExp=3D!gOtlTxtExp UpdOtlPane() } function ClearMedia() { // Clear any sounds playing before launching another browser window. Other= wise, // in fullscreen mode, you'll continue to hear the sound in the frames mod= e. if (PPTSld.pptSound) PPTSld.pptSound.loop =3D 0; } function FullScreen() {=20 if ( PPTSld.g_animUseRuntime ) PPTSld.document.body.pause(); ClearMedia(); var href =3D ( document.location.protocol =3D=3D 'mhtml:') ? FULLSCR_HREF = : FULLSCR_HREF+"#"+GetHrefObj(gCurSld).mSldHref; if(PPTNav.event.ctrlKey) { var w =3D (window.screen.availWidth * 1.0) / 2.0 var h =3D w * (PPTSld.g_origH * 1.0) / PPTSld.g_origW win =3D window.open( MHTMLPrefix+href,null,"toolbar=3D0,resizable=3D1,top= =3D0,left=3D0," + "width=3D"+ w + ",height=3D" + h ); if( win.document.body && PPTSld.g_animUseRuntime ) win.document.body.PPTSldFrameset=3Dwindow; } else { win =3D window.open( MHTMLPrefix+href,null,"fullscreen=3Dyes" ); if( win.document.body && PPTSld.g_animUseRuntime ) win.document.body.PPTSldFrameset=3Dwindow; } } function ToggleVNarration() { rObj=3DPPTSld.document.all("NSPlay") if( rObj && !PPTSld.g_animUseRuntime ) { if( (rObj.playState =3D=3D 1)||(rObj.playState =3D=3D 0) ) rObj.Play() else if( rObj.playState =3D=3D 2 ) rObj.Pause() else return; } else if( PPTSld.g_animUseRuntime ) { narObj =3D PPTSld.document.all("narrationID") if( narObj ) narObj.togglePause() } } function GetCurSldNum() { =20 obj=3DGetHrefObj(gCurSld) if( obj.mOrigVis =3D=3D 1 ) return obj.mSldIdx else =20 return gCurSld } function GetNumSlds() { =20 if( GetHrefObj(gCurSld).mOrigVis =3D=3D 1 ) return GetSldList().mNumVisSlds; else return GetSldList().mList.length } function GetSldNum( href ) { for(ii=3D0; ii 1 ) PopSldList(); else if( !IsFramesMode() ) { if( gLoopCont ) GoToFirst() else EndShow() } } function GoToPrevSld() { ii=3DgCurSld-1 if( ii > 0 ) { obj=3DGetHrefObj(ii) while ( obj && ( obj.mVis =3D=3D 0 ) && ( ii>0 ) ) obj=3DGetHrefObj(--ii) if( ii =3D=3D 0 ) ii=3D1 GoToSldNum(ii) } } function GoToFirst(){ GoToSld( GetHrefObj(1).mSldHref ) } function GoToLast() { ii=3DGetSldList().mList.length if( ii !=3D gCurSld ) GoToSld( GetHrefObj(ii).mSldHref ) } function GoToSldNum( num ) { if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue obj =3D GetHrefObj( num ) obj.mVis=3D1 gPrevSld=3DgCurSld gCurSld =3D num; PPTSld.location.replace(MHTMLPrefix+obj.mSldHref) if( IsFramesMode() ) { UpdNavPane(); UpdOtlPane(); UpdNtsPane() } } function GoToSld( href ) { if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue GetHrefObj( GetSldNum(href) ).mVis=3D1 PPTSld.location.replace(MHTMLPrefix+href) } function SldUpdated( id ) { if( id =3D=3D GetHrefObj(gCurSld).mSldHref ) return gPrevSld=3DgCurSld gCurSld=3DGetSldNum(id) if( IsFramesMode() ) { UpdNavPane(); UpdOtlPane(); UpdNtsPane() } } function PrevSldViewed(){ GoToSld( GetHrefObj(gPrevSld).mSldHref ) } function HasPrevSld() { return ( gIsEndShow || ( gCurSld !=3D 1 && GetHrefO= bj( gCurSld-1 ).mVis =3D=3D 1 )||( GetCurSldNum() > 1 ) ) } function HasNextSld() { return (GetCurSldNum() !=3D GetNumSlds()) } function CloseWindow() { if( HideMenu() ) return; =09 var event =3D PPTSld.event; if( !IsFramesMode() && event && (event.keyCode=3D=3D27 || event.keyCode=3D= =3D32 || event.type=3D=3D"click" ) ) window.close( self ); CatchNumKeys( self, event ); } function Unload() { gIsEndShow=3D0; } function SetupEndShow() { gIsEndShow=3D1; PPTSld.document.body.scroll=3D"no"; PPTSld.document.onkeypress=3DCloseWindow; PPTSld.document.onclick=3DCloseWindow; PPTSld.document.oncontextmenu=3D_CM; } function EndShow() { if( IsFramesMode() ) return if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue doc=3DPPTSld.document var dir =3D doc.body.dir if( dir !=3D "rtl" ) dir =3D "ltr"; doc.open() doc.writeln('

' + ENDSHOW_MESG + '
') doc.close() } function SetSldVisited(){ GetSldList().mList[gCurSld-1].mVisited=3Dtrue } function IsSldVisited(){ return GetSldList().mList[gCurSld-1].mVisited } function hrefList( sldHref, visible, advDelay, advClk ) { this.mSldHref=3D this.mNtsHref =3D sldHref this.mOrigVis=3D this.mVis =3D visible this.mVisited=3D false this.mAdvDelay=3D advDelay this.mAdvOnClk=3D advClk } function SldList(arr,curSld,fEnd) { this.mCurSld =3D curSld; this.mList =3D new Array(); var idx =3D 1; for(ii=3D0;ii 0) { PushSldList(sldList,fEnd); gCurSld =3D 1; } else if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue } function PushSldList(arr,fEnd) { var ii =3D gSldStack.length; gSldStack[ii] =3D new SldList(arr,gCurSld,fEnd); GoToSld( gSldStack[ii].mList[0].mSldHref ); } function PopSldList() { if (gSldStack[gSldStack.length-1].fEndShow) EndShow() else { gCurSld =3D gSldStack[gSldStack.length-1].mCurSld; gSldStack[gSldStack.length-1] =3D null; gSldStack.length--; var sldList =3D gSldStack[gSldStack.length-1]; GoToSld( sldList.mList[gCurSld - 1].mSldHref ); } } var custShowList=3Dnew Array(); /********************************************* Navigation button implementation There are 2 types of buttons: ImgBtn, TxtBtn implemented as function objects. They share a similiar interface so the event handlers can call SetActive, for example, on a button=20 object without needing to know exactly=20 what type of button it is. **********************************************/ //---------------------------------- function ImgBtn( oId,bId,w,action ) //---------------------------------- { var t=3Dthis t.Perform =3D _IBP t.SetActive =3D _IBSetA t.SetInactive=3D _IBSetI t.SetPressed =3D _IBSetP t.SetDisabled=3D _IBSetD t.Enabled =3D _IBSetE t.ChangeIcon =3D null t.UserAction =3D action t.ChgState =3D _IBUI t.mObjId =3D oId t.mBorderId=3D bId t.mWidth =3D w t.mIsOn =3D t.mCurState =3D 0 } function _IBSetA() { if( this.mIsOn ) { obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 ) obj.style.posTop=3D0 } } function _IBSetI() { if( this.mIsOn ) { obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 ) obj.style.posTop=3D0=20 } } function _IBSetP() { if( this.mIsOn ) { obj=3Dthis.ChgState( gShadowClr,gHiliteClr,2 ) obj.style.posLeft+=3D1; obj.style.posTop+=3D1 } } function _IBSetD() { =20 obj=3Dthis.ChgState( gFaceClr,gFaceClr,0 ) obj.style.posTop=3D0=20 } function _IBSetE( state ) { var t=3Dthis GetObj( t.mBorderId ).style.visibility=3D"visible" if( state !=3D t.mIsOn ) { t.mIsOn=3Dstate if( state ) t.SetInactive() else t.SetDisabled() } } function _IBP() { var t=3Dthis if( t.mIsOn ) { if( t.UserAction !=3D null ) t.UserAction() if( t.ChangeIcon ) { obj=3DGetObj(t.mObjId) if( t.ChangeIcon() ) obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-4)*t.mWidth else obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-0)*t.mWidth } t.SetActive() } =20 } function _IBUI( clr1,clr2,nextState ) { var t=3Dthis SetBorder( GetObj( t.mBorderId ),clr1,clr2 ) obj=3DGetObj( t.mObjId ) obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-nextState)*t.mWidth-obj= .style.posTop t.mCurState=3DnextState return obj } //----------------------------------------- function TxtBtn( oId,oeId,action,chkState ) //----------------------------------------- { var t=3Dthis t.Perform =3D _TBP t.SetActive =3D _TBSetA t.SetInactive=3D _TBSetI t.SetPressed =3D _TBSetP t.SetDisabled=3D _TBSetD t.SetEnabled =3D _TBSetE t.GetState =3D chkState t.UserAction =3D action t.ChgState =3D _TBUI t.mObjId =3D oId t.m_elementsId=3D oeId t.mIsOn =3D 1 } function _TBSetA() { var t=3Dthis if( t.mIsOn && !t.GetState() ) t.ChgState( gHiliteClr,gShadowClr,0,0 ) } function _TBSetI() { var t=3Dthis if( t.mIsOn && !t.GetState() ) t.ChgState( gFaceClr,gFaceClr,0,0 ) } function _TBSetP() { if( this.mIsOn ) this.ChgState( gShadowClr,gHiliteClr,1,1 ) } function _TBSetD() { =20 this.ChgState( gFaceClr,gFaceClr,0,0 ) this.mIsOn =3D 0 } function _TBSetE() { var t=3Dthis if( !t.GetState() ) t.ChgState( gFaceClr,gFaceClr,0,0 ) else t.ChgState( gShadowClr,gHiliteClr,1,1 ) t.mIsOn =3D 1 } function _TBP() { var t=3Dthis if( t.mIsOn ) {=20 if( t.UserAction !=3D null ) t.UserAction() if( !t.GetState ) return if( t.GetState() ) t.SetPressed() else t.SetActive() } =20 } function _TBUI( clr1,clr2,lOffset,tOffset ) { SetBorder( GetObj( this.mObjId ),clr1,clr2 ) Offset( GetObj( this.m_elementsId ),lOffset,tOffset ) } function Offset( obj, top, left ){ obj.style.top=3Dtop; obj.style.left=3Dle= ft } function SetBorder( obj, upperLeft, lowerRight ) { s=3Dobj.style; s.borderStyle =3D "solid" s.borderWidth =3D 1=20 s.borderLeftColor =3D s.borderTopColor =3D upperLeft s.borderBottomColor=3D s.borderRightColor =3D lowerRight } function GetBtnObj(){ return gBtnArr[window.event.srcElement.id] } function BtnOnOver(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetActive() } function BtnOnDown(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetPressed() } function BtnOnOut(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetInactive() } function BtnOnUp() { b=3DGetBtnObj() if( b !=3D null ) b.Perform() else Upd() } function GetNtsState(){ return parent.gNtsOpen } function GetOtlState(){ return parent.gOtlOpen } function GetOtlTxtState(){ return parent.gOtlTxtExp } function NtsBtnSetFlag( fVal ) { s=3Ddocument.all.item( this.m_flagId ).style s.display=3D"none" if( fVal ) s.display=3D"" else s.display=3D"none" } function _BSetA_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etActive() } function _BSetI_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etInactive() } function _BSetP_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etPressed() } function _BSetA_BorderImg() {=20 b =3D gBtnArr[this.mBorderId]=20 if( b !=3D null && this.mIsOn && !b.GetState() ) { obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 ) obj.style.posTop=3D0 } } function _BSetI_BorderImg() {=20 b =3D gBtnArr[this.mBorderId] if( b !=3D null && this.mIsOn && !b.GetState() ) { obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 ) obj.style.posTop=3D0 } } var gHiliteClr=3D"THREEDHIGHLIGHT",gShadowClr=3D"THREEDSHADOW",gFaceClr=3D"= THREEDFACE" var gBtnArr =3D new Array() gBtnArr["nb_otl"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOtlPan= e,GetOtlState ) gBtnArr["nb_otlElem"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOt= lPane,GetOtlState ) gBtnArr["nb_nts"] =3D new ImgBtn( "nb_nts","nb_ntsBorder",10,parent.ToggleN= tsPane ) gBtnArr["nb_nts"].SetActive =3D _BSetA_BorderImg; gBtnArr["nb_nts"].SetInactive =3D _BSetI_BorderImg; gBtnArr["nb_ntsBorder"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.= ToggleNtsPane,GetNtsState ) gBtnArr["nb_ntsElem"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.To= ggleNtsPane,GetNtsState ) gBtnArr["nb_prevBorder"] =3D gBtnArr["nb_prev"]=3D new ImgBtn( "nb_prev","n= b_prevBorder",30,parent.GoToPrevSld ) gBtnArr["nb_nextBorder"] =3D gBtnArr["nb_next"]=3D new ImgBtn( "nb_next","n= b_nextBorder",30,parent.GoToNextSld ) gBtnArr["nb_sldshw"]=3D new ImgBtn( "nb_sldshw","nb_sldshwBorder",18,parent= .FullScreen ) gBtnArr["nb_sldshwBorder"] =3D new TxtBtn( "nb_sldshw","nb_sldshwBorder",pa= rent.FullScreen,null ) gBtnArr["nb_sldshwBorder"].SetActive =3D _BSetA_Border; gBtnArr["nb_sldshwBorder"].SetInactive =3D _BSetI_Border; gBtnArr["nb_sldshwText"] =3D new TxtBtn( "nb_sldshw","nb_sldshwText",parent= .FullScreen,null ) gBtnArr["nb_sldshwText"].SetActive =3D _BSetA_Border; gBtnArr["nb_sldshwText"].SetInactive =3D _BSetI_Border; gBtnArr["nb_voice"] =3D gBtnArr["nb_voiceBorder"] =3D new ImgBtn( "nb_voice= ","nb_voiceBorder",18,parent.ToggleVNarration ) gBtnArr["nb_otlTxtBorder"] =3D gBtnArr["nb_otlTxt"]=3D new ImgBtn( "nb_otlT= xt","nb_otlTxtBorder",23,parent.ToggleOtlText ) gBtnArr["nb_ntsBorder"].m_flagId=3D "nb_nts" gBtnArr["nb_ntsBorder"].SetFlag =3D NtsBtnSetFlag gBtnArr["nb_otlTxt"].ChangeIcon=3D GetOtlTxtState /********************************************* Context menu implementation _CM() is the function that's hooked up to the oncontextmenu event. Once we're asked to show the menu, we first build it by creating DIVs on-the-fly. Then we position it=20 within the screen area so it doesn't get clipped. Creating the DIVs using createElement() means we don't have to write out any extra HTML into the slide HTML files. **********************************************/ var sNext=3D"下一步",sPrev=3D"上一步",s= End=3D"结束放映",sFont=3D"宋体",sArrow= =3D"箭头",sFreeform=3D"任意形状",sRect= =3D"矩形",sOval=3D"椭圆" function ShowMenu() { BuildMenu(); var doc=3DPPTSld.document.body,x=3DPPTSld.event.clientX+doc.scrollLeft,y= =3DPPTSld.event.clientY+doc.scrollTop m =3D PPTSld.document.all.item("ctxtmenu") m.style.pixelLeft=3Dx if( (x+m.scrollWidth > doc.clientWidth)&&(x-m.scrollWidth > 0) ) m.style.pixelLeft=3Dx-m.scrollWidth m.style.pixelTop=3Dy if( (y+m.scrollHeight > doc.clientHeight)&&(y-m.scrollHeight > 0) ) m.style.pixelTop=3Dy-m.scrollHeight m.style.display=3D"" } function _CM() { if( !parent.IsFullScrMode() ) return; if(!PPTSld.event.ctrlKey) { ShowMenu() return false } else HideMenu() } function BuildMenu() { if( PPTSld.document.all.item("ctxtmenu") ) return var mObj=3DCreateItem( PPTSld.document.body ) mObj.id=3D"ctxtmenu" mObj.style.visibility=3D"hidden" var s=3DmObj.style s.position=3D"absolute" s.cursor=3D"default" s.width=3D"120px" SetCMBorder(mObj,"menu","black") var iObj=3DCreateItem( mObj ) SetCMBorder( iObj, "threedhighlight","threedshadow" ) iObj.style.padding=3D2 CreateMenuItem( iObj,sNext,M_GoNextSld,M_True ) CreateMenuItem( iObj,sPrev,M_GoPrevSld,M_HasPrevSld ) =09 CreateSeparator( iObj ) CreateMenuItem( iObj,sEnd,M_End,M_True ) mObj.style.visibility=3D"visible" } function Cancel() { window.event.cancelBubble=3Dtrue; window.event.returnVa= lue=3Dfalse } function Highlight() { ChangeClr("activecaption","threedhighlight") } function Deselect() { ChangeClr("threedface","menutext") } function Perform() { e=3DPPTSld.event.srcElement if( e.type=3D=3D"menuitem" && e.IsActive() ) e.Action() else PPTSld.event.cancelBubble=3Dtrue } function ChangeClr( bg,clr ) { e=3DPPTSld.event.srcElement if( e.type=3D=3D"menuitem" && e.IsActive() ) { e.style.backgroundColor=3Dbg e.style.color=3Dclr } } function M_HasPrevSld() { return( parent.HasPrevSld() ) } function M_GoNextSld() { if( gIsEndShow ) M_End(); else GoToNextSld() } function M_GoPrevSld() { if( gIsEndShow ) { gIsEndShow=3D0; history.back();= PPTSld.event.cancelBubble=3Dtrue; } else GoToPrevSld() } function M_True() { return true } function M_End() { window.close( self ) } function CreateMenuItem( node,text,action,eval ) { var e=3DCreateItem( node ) e.type=3D"menuitem" e.Action=3Daction e.IsActive=3Deval e.innerHTML=3Dtext if( !e.IsActive() ) e.style.color=3D"threedshadow" e.onclick=3DPerform e.onmouseover=3DHighlight e.onmouseout=3DDeselect s=3De.style; s.fontFamily=3DsFont s.fontSize=3D"9pt" s.paddingLeft=3D2 } function CreateSeparator( node ) { var sObj=3DCreateItem( node ) SetCMBorder(sObj,"menu","menu") var s=3DsObj.style s.borderTopColor=3D"threedshadow" s.borderBottomColor=3D"threedhighlight" s.height=3D1 s.fontSize=3D"0px" } function CreateItem( node ) { var elem=3DPPTSld.document.createElement("DIV") node.insertBefore( elem ) return elem } function SetCMBorder( o,ltClr,rbClr ) { var s=3Do.style s.backgroundColor=3D"menu" s.borderStyle=3D"solid" s.borderWidth=3D1 s.borderColor=3DltClr+" "+rbClr+" "+rbClr+" "+ltClr } ------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/fullscreen.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" ------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/buttons.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhWAESAPf4AAAAAIAAAACAAICAAAAAgIAAgACAgICAgAQEBISEBASEBISEhAQEhMTExAQE /KTM9Pz8/ERERPz8BAT8/KSkpGRkhMTcxCRkxAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAMDAwP8AAAD/AP//AAAA//8A/wD//////yH5BAEAAPgALAAAAABYARIA QAj/APEJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGCEiQKCRo8YDIEHig2DxAD4LKD1avDDhgUuV GUOGbHBR5QGYFBG4fHAB58EKECJEwCfUYAWPFGAygLCRKQIIUKM6WAohKUGgCikcFWh1INWoYKVS 7SrQ41GbIhGYLAuVQVOoC+IyXUuUAkG1HE3KFDhAwkgJc5/qDZmxsOHDiBMrXsy4sePDGyP7lChT 5MULmDPnlDw5YmW6FTNrfgi0aNGEZPEtbfo2bNTUpYeeRph69dPWrqvCNFuBIGG1A59CYPAVQtwF cw0OxWdTIOiBCQAjaAB17fOFII8voGmRc+eOkilm/z9OvTtnjN4hYk1YoT3H2rnBOphPAB9skgq3 2lcaX/5YnJVt9BloAar12UEIRGCZdQghMABI1Tn32IQUVthYexhmqGGGMBHAgIfEhSiiiATAtOGJ GnYI4ogsEldicAYOGNJGZaml3Y0L3NTZUBz1xlB0PUoUI0jlVWRSVN89xBKSGB1YU1TMoRfVBEle hR9HQs1GEHxQ3RZZbveZthxt/LEmXHyp5XWABSCpaRJwbM13gAACPHVccgJFgF+NEhqUAEkQSCfc ddhVhh5dVTaEAEsTUNlkZUWKN9BNGDE6QU8OrSdbllzpxyVTTrU21Uj3scfhp7nNpyoDaTIEJ3P9 If8J2kbLNYegg9JRBwGhFvbq66+ZUiDssMQWK2yHxiZLrInKNotss8l+B5yBrr5p2UIJvortANoC 6+234IbLla/elRtZjeamh5CC3Sb0YLvixivvYkDFGlZqBNh7r4n6goVvv6/ZlCicN+kL71ALTnpQ dCIZp7CihkLA3UQmoWRBogyxtBPGCTnZncVR1rSTo5nuydC/Eo8kUH+lOoTyyvjoCuZu+PjYIKLD rZybtrM1d10C0QXKEVz48GrQkEeWdFJKlbb0UmEeV0SzyC6RvNB646LWIVjUNeC1zAFb+RDKXksM 9r531bwmpQW9+hQDDsx5pqwDRWBXcFES2hc+gEn/wJGdEEWdE6LoWcoxQweaTNmkhydkKaYMYY2Q p1unbLl/pPKbn3v7EZRvrKvqlja2ONvrtoIw9tn2g32/tQBlhtYkU+MNikZ7QYlPDPuMldpOmuJX nVo5VF3HjI+q89mteX5IDd/fVFClma5kiE4f2XUJhlz09gj2NbTDRifkmu7zXjR++RVJ/lPznuvr QH2iD6S+UewP9Dnon6d2NLwN8n90BB6hC68cFMCHoe+ACASP9c4DowUyEF0OPFcDI0ij/VXPaAKC UfhS95AKGoQ7IBRICI1HwhGaUIQoLGEKT6jCFrLwhSuMoQtlCMMZ2rCGOKShDm+4wxzy8Ic+DGIP B4cIRCKGMCAAOy== ------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/frame.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" 菠菜技术交流论坛 - 菠菜最新优惠活动论坛 ------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/outline.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"

&#= 22791;注

大纲

1

实验= 二：管理SQL Server 2005数据库

指导教师：谢文全

信阳师范学院城环&= 498;GIS教研室

二零一六年四月

2

"一&#= 12289;实验类型"

一、实验类型

验证性

二、实验目的

了解数据库常用对= 5937;及组成；

熟悉SQL的基本概念和= 特点；

熟练掌握T-SQL 语句中į= 40;数据定义的使用方法= ；

熟悉在SQL Server 2005中创建= 450;编辑数据库；

熟练掌握SQL的数据定= 义子句的使用方法。

3

"三&#= 12289;实验环境"

三、实验环境

已安装SQL Server 2005计算机A= 307;

具有局域网网络环= 2659;，有固定ip地址；

四、实验学时

2学时

五、实验要求

熟练使用Management Stuio界面= 6041;式创建及编辑数据ॵ= 1;；

熟练使用T-SQL 语句创ó= 14;及编辑数据库；

完成实验报告。

4

"五&#= 12289;实验准备知识（也...&q= uot;

五、实验准备知识A= 288;也可参考SQL Server联机丛书）

数据库相关属性

逻辑名称：数据文= 0214;和日志文件名称

文件类型：数据文= 0214;及日志文件

文件组：各个数据= 5991;件所属的文件组名ఱ= 6;

初始大小：文件的= 6368;原始大小

自动增长：文件按= 5351;定的大小增长，也ࡤ= 7;限制到最大容量。

路径：存放文件的= 9289;理目录

文件名：显示数据= 5991;件和日志文件的物ச= 2;名称

默认数据库属性

主数据文件为xx.mdf ，= 085;志文件为xx_log.ldf；

只有一个文件组PrimaryA= 307;

主数据文件初始大= 3567;为3MB，增量为1MB；

日志文件初始大小= 0026;1MB，增量为10%；

主数据文件和日志= 5991;件都存放在C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA目录ߍ= 9;，文件分别为xx.mdf 和xx_log.ldf 。

5

"使&#= 29992;界面创建数据库步Ƌ= 88;"

使用界面创建数据= 211;步骤

【SQL Server Management Studio】→【对= 象资源管理器】→【= 968;据库】→【新建数据= 库】→设置数据库相= 851;属性（名称、大小、= ;位置）

启动SQL Server 2005查询分析Ý= 20;

【SQL Server Management Studio】→【新= 建查询】

命令方式下创建数= 454;库

CREATE DATABASE database_name /*指定数据库名*/

[ON 子句 ] &nbs= p; &= nbsp; &nbs= p; /*指定数据库文件&#= 21644;文件组属性

[LOG ON 子Ö= 77; ] &nbs= p; &= nbsp; &nbs= p; /*指定日志文件属&#= 24615;*/

命令方式修改数据= 211;

Alter database database_name

{add file <filespec>[,…n] [to filegroup filegroupname]<= /li>
|add log file <filespec>[,…n]

|remove file logical_file_name [with delete]

|modify file <filespec>

6

"七&#= 12289;实验内容及步骤"

七、实验内容及步'= 588;

1、假设SQL Server服务已启&= #21160;，并以Administrator身份登录= ;计算机（文件名称自&#= 23450;）；请分别使用Management= 0028;面方式和T-SQL语句实现&= #20197;下操作：

要求在本地磁盘D创&#= 24314;一个学生-课程数据= 211;（名称为student），只有= 一个数据文件和日志= 5991;件，文件名称分别ߒ= 6;stu和stu_log，物理名称为stu_dat= a.mdf 和stu_log.ldf，初始大小都= 为3MB，增长方式分别为= 10%和1MB，数据文件最大È= 26;500MB，日志文件大小不= 1463;限制。

创建一个Company数据库A= 292;该数据库的主数据文= ;件逻辑名称为Company_data，୰= 9;理文件为Company.mdf，初始࣪= 3;小为10MB，最大尺寸为Ą= 80;限大，增长速度为10%ʍ= 07;数据库的日志文件逻= 辑名称为Company_log，物理文= 件名为Company.ldf，初始大小= 为1MB，最大尺寸为50MB，= 686;长速度为1MB。

创建数据库DB，具有2= 个数据文件，文件逻= 6753;名分别为DB_data1和DB_data2，ਧ= 1;件初始大小均为5MB，ੌ= 8;大为100MB，按10%增长；只&= #26377;一个日志文件，初= 987;大小为3MB，按10%增长；&= #25152;有文件都存储在D盘= 5991;件夹ceshi中。

7

"在&#= 25968;据库student中增加数据...&qu= ot;

在数据库student中增加= 968;据文件db2，初始大小= 026;10MB，最大大小为50 MB，按10%增长；

在数据库student中添加= 085;志文件，保存在D盘ߑ= 3;，初始大小为1MB，最࣪= 3;无限制，增长方式按&= #29031;1MB增长；

修改数据库student主数= 454;文件的大小，将主数= ;据文件的初始大小修&#= 25913;为10Mb，增长方式为20%ᦂ= 7;

修改数据库student辅助= 968;据文件初始大小为3MBA= 292;最大为100MB，按照10%增长= ;，名称为db;

删除数据库student辅助= 968;据文件和第二个日志= ;文件；

删除数据库company和DB。

2、将数据库student的所= 377;物理文件移动到‘D:\xxx&#= 8216;,并且保证逻辑数据ò= 11;不受影响，请详细描= 述解决办法

8

"八&#= 12289;讨论出现问题及解Ñ= 15;..."

八、讨论出现问题= 450;解决办法

如某些操作无法执= 4892;，如何解决？

------=_NextPart_01D1A23D.9E5D1460 Content-Location: file:///C:/87AB980C/file9740.files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01D1A23D.9E5D1460--

1	实验= 二：管理SQL Server 2005数据库指导教师：谢文全信阳师范学院城环&= 498;GIS教研室二零一六年四月
2	"一&#= 12289;实验类型" 一、实验类型验证性二、实验目的了解数据库常用对= 5937;及组成；熟悉SQL的基本概念和= 特点；熟练掌握T-SQL 语句中į= 40;数据定义的使用方法= ；熟悉在SQL Server 2005中创建= 450;编辑数据库；熟练掌握SQL的数据定= 义子句的使用方法。
3	"三&#= 12289;实验环境" 三、实验环境已安装SQL Server 2005计算机A= 307; 具有局域网网络环= 2659;，有固定ip地址；四、实验学时 2学时五、实验要求熟练使用Management Stuio界面= 6041;式创建及编辑数据ॵ= 1;；熟练使用T-SQL 语句创ó= 14;及编辑数据库；完成实验报告。
4	"五&#= 12289;实验准备知识（也...&q= uot; 五、实验准备知识A= 288;也可参考SQL Server联机丛书）数据库相关属性逻辑名称：数据文= 0214;和日志文件名称文件类型：数据文= 0214;及日志文件文件组：各个数据= 5991;件所属的文件组名ఱ= 6; 初始大小：文件的= 6368;原始大小自动增长：文件按= 5351;定的大小增长，也ࡤ= 7;限制到最大容量。路径：存放文件的= 9289;理目录文件名：显示数据= 5991;件和日志文件的物ச= 2;名称默认数据库属性主数据文件为xx.mdf ，= 085;志文件为xx_log.ldf；只有一个文件组PrimaryA= 307; 主数据文件初始大= 3567;为3MB，增量为1MB；日志文件初始大小= 0026;1MB，增量为10%；主数据文件和日志= 5991;件都存放在C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA目录ߍ= 9;，文件分别为xx.mdf 和xx_log.ldf 。
5	"使&#= 29992;界面创建数据库步Ƌ= 88;" 使用界面创建数据= 211;步骤【SQL Server Management Studio】→【对= 象资源管理器】→【= 968;据库】→【新建数据= 库】→设置数据库相= 851;属性（名称、大小、= ;位置）启动SQL Server 2005查询分析Ý= 20; 【SQL Server Management Studio】→【新= 建查询】命令方式下创建数= 454;库 CREATE DATABASE database_name /指定数据库名/ [ON 子句 ] &nbs= p; &= nbsp; &nbs= p; /指定数据库文件&#= 21644;文件组属性 [LOG ON 子Ö= 77; ] &nbs= p; &= nbsp; &nbs= p; /指定日志文件属&#= 24615;*/ 命令方式修改数据= 211; Alter database database_name {add file <filespec>[,…n] [to filegroup filegroupname]<= /li> \|add log file <filespec>[,…n] \|remove file logical_file_name [with delete] \|modify file <filespec>
6	"七&#= 12289;实验内容及步骤" 七、实验内容及步'= 588; 1、假设SQL Server服务已启&= #21160;，并以Administrator身份登录= ;计算机（文件名称自&#= 23450;）；请分别使用Management= 0028;面方式和T-SQL语句实现&= #20197;下操作：要求在本地磁盘D创&#= 24314;一个学生-课程数据= 211;（名称为student），只有= 一个数据文件和日志= 5991;件，文件名称分别ߒ= 6;stu和stu_log，物理名称为stu_dat= a.mdf 和stu_log.ldf，初始大小都= 为3MB，增长方式分别为= 10%和1MB，数据文件最大È= 26;500MB，日志文件大小不= 1463;限制。创建一个Company数据库A= 292;该数据库的主数据文= ;件逻辑名称为Company_data，୰= 9;理文件为Company.mdf，初始࣪= 3;小为10MB，最大尺寸为Ą= 80;限大，增长速度为10%ʍ= 07;数据库的日志文件逻= 辑名称为Company_log，物理文= 件名为Company.ldf，初始大小= 为1MB，最大尺寸为50MB，= 686;长速度为1MB。创建数据库DB，具有2= 个数据文件，文件逻= 6753;名分别为DB_data1和DB_data2，ਧ= 1;件初始大小均为5MB，ੌ= 8;大为100MB，按10%增长；只&= #26377;一个日志文件，初= 987;大小为3MB，按10%增长；&= #25152;有文件都存储在D盘= 5991;件夹ceshi中。
7	"在&#= 25968;据库student中增加数据...&qu= ot; 在数据库student中增加= 968;据文件db2，初始大小= 026;10MB，最大大小为50 MB，按10%增长；在数据库student中添加= 085;志文件，保存在D盘ߑ= 3;，初始大小为1MB，最࣪= 3;无限制，增长方式按&= #29031;1MB增长；修改数据库student主数= 454;文件的大小，将主数= ;据文件的初始大小修&#= 25913;为10Mb，增长方式为20%ᦂ= 7; 修改数据库student辅助= 968;据文件初始大小为3MBA= 292;最大为100MB，按照10%增长= ;，名称为db; 删除数据库student辅助= 968;据文件和第二个日志= ;文件；删除数据库company和DB。 2、将数据库student的所= 377;物理文件移动到‘D:\xxx&#= 8216;,并且保证逻辑数据ò= 11;不受影响，请详细描= 述解决办法
8	"八&#= 12289;讨论出现问题及解Ñ= 15;..." 八、讨论出现问题= 450;解决办法如某些操作无法执= 4892;，如何解决？