无锡学院《数据库原理》实验报告+SQL语句源程序文档

[{"title":"（ 58 个子文件 3.91MB ） 无锡学院《数据库原理》实验报告+SQL语句源程序文档","children":[{"title":"5实验五：触发器的创建与使用","children":[{"title":"3.修改触发器.sql <span style='color:#111;'> 120B </span>","children":null,"spread":false},{"title":"4.禁用、启用触发器.sql <span style='color:#111;'> 118B </span>","children":null,"spread":false},{"title":"1.1创建DML触发器.sql <span style='color:#111;'> 206B </span>","children":null,"spread":false},{"title":"实验五：触发器的创建与使用.doc <span style='color:#111;'> 482.00KB </span>","children":null,"spread":false},{"title":"2.1创建DDL触发器2.sql <span style='color:#111;'> 301B </span>","children":null,"spread":false},{"title":"2.1创建DDL触发器.sql <span style='color:#111;'> 319B </span>","children":null,"spread":false}],"spread":true},{"title":"1实验一：创建各种数据库","children":[{"title":"实验一：创建各种数据库.doc <span style='color:#111;'> 834.00KB </span>","children":null,"spread":false},{"title":"创建数据库的SQL语法.sql <span style='color:#111;'> 204B </span>","children":null,"spread":false},{"title":"创建指定大小的数据库.sql <span style='color:#111;'> 553B </span>","children":null,"spread":false},{"title":"创建使用默认参数的数据库.sql <span style='color:#111;'> 19B </span>","children":null,"spread":false},{"title":"创建指定数据文件的数据库.sql <span style='color:#111;'> 334B </span>","children":null,"spread":false},{"title":"SQLQuery1.sql <span style='color:#111;'> 547B </span>","children":null,"spread":false},{"title":"创建指定文件组的数据库.sql <span style='color:#111;'> 804B </span>","children":null,"spread":false},{"title":"~$一：创建各种数据库.doc <span style='color:#111;'> 162B </span>","children":null,"spread":false},{"title":"创建带多个数据文件的数据库.sql <span style='color:#111;'> 304B </span>","children":null,"spread":false}],"spread":true},{"title":"2实验二：表结构的创建和修改","children":[{"title":"3、student表的删除字段.sql <span style='color:#111;'> 37B </span>","children":null,"spread":false},{"title":"实验二：表结构的创建和修改.doc <span style='color:#111;'> 401.50KB </span>","children":null,"spread":false},{"title":"数据表的创建2【代码】.sql <span style='color:#111;'> 109B </span>","children":null,"spread":false},{"title":"2、student表的修改字段.sql <span style='color:#111;'> 56B </span>","children":null,"spread":false},{"title":"~WRL2399.tmp <span style='color:#111;'> 25.50KB </span>","children":null,"spread":false},{"title":"1、student表的增加字段.sql <span style='color:#111;'> 47B </span>","children":null,"spread":false},{"title":"~$二：表结构的创建和修改.doc <span style='color:#111;'> 162B </span>","children":null,"spread":false},{"title":"数据表的创建【代码】.sql <span style='color:#111;'> 90B </span>","children":null,"spread":false}],"spread":true},{"title":"11实验十一：数据库的备份和恢复","children":[{"title":"1.数据库的备份.sql <span style='color:#111;'> 307B </span>","children":null,"spread":false},{"title":"实验十一：数据库的备份和恢复.doc <span style='color:#111;'> 364.00KB </span>","children":null,"spread":false},{"title":"2.数据库的恢复.sql <span style='color:#111;'> 299B </span>","children":null,"spread":false}],"spread":true},{"title":"8实验八：数据的安全性控制","children":[{"title":"3.创建架构.sql <span style='color:#111;'> 189B </span>","children":null,"spread":false},{"title":"2.为创建用户赋予超级权限.sql <span style='color:#111;'> 216B </span>","children":null,"spread":false},{"title":"实验八：数据的安全性控制.doc <span style='color:#111;'> 157.00KB </span>","children":null,"spread":false},{"title":"1.创建SQL server登录.sql <span style='color:#111;'> 48B </span>","children":null,"spread":false}],"spread":true},{"title":"4实验四：索引和视图的创建、查看、删除","children":[{"title":"2.3删除视图.sql <span style='color:#111;'> 17B </span>","children":null,"spread":false},{"title":"2.1创建视图.sql <span style='color:#111;'> 145B </span>","children":null,"spread":false},{"title":"1.4删除索引.sql <span style='color:#111;'> 35B </span>","children":null,"spread":false},{"title":"1.2查看数据表上所有索引.sql <span style='color:#111;'> 60B </span>","children":null,"spread":false},{"title":"1.3查看数据库上所有索引.sql <span style='color:#111;'> 85B </span>","children":null,"spread":false},{"title":"2.2查看视图.sql <span style='color:#111;'> 19B </span>","children":null,"spread":false},{"title":"实验四：索引和视图的创建、查看和删除.doc <span style='color:#111;'> 354.50KB </span>","children":null,"spread":false},{"title":"1.1创建降序聚集索引.sql <span style='color:#111;'> 63B </span>","children":null,"spread":false}],"spread":true},{"title":"3实验三：表数据的插入、删除和更新","children":[{"title":"3、表数据的更新.sql <span style='color:#111;'> 82B </span>","children":null,"spread":false},{"title":"2、表数据的删除.sql <span style='color:#111;'> 86B </span>","children":null,"spread":false},{"title":"1、表数据的插入.sql <span style='color:#111;'> 107B </span>","children":null,"spread":false},{"title":"实验三：表数据的插入、删除和更新.doc <span style='color:#111;'> 211.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"10实验十：程序设计和运行","children":[{"title":"1.定义并赋值.sql <span style='color:#111;'> 150B </span>","children":null,"spread":false},{"title":"实验十：程序设计和运行.doc <span style='color:#111;'> 217.00KB </span>","children":null,"spread":false},{"title":"2.查询并按等级输出成绩.sql <span style='color:#111;'> 280B </span>","children":null,"spread":false}],"spread":true},{"title":"6实验六：表之间关系图创建","children":[{"title":"实验六：表之间关系图创建.doc <span style='color:#111;'> 61.50KB </span>","children":null,"spread":false}],"spread":true},{"title":"7实验七：数据的导入和导出","children":[{"title":"实验七：数据的导入和导出.doc <span style='color:#111;'> 1018.50KB </span>","children":null,"spread":false}],"spread":true},{"title":"9实验九：查询的创建和使用","children":[{"title":"2.1带DISTINCT的查询.sql <span style='color:#111;'> 50B </span>","children":null,"spread":false},{"title":"6.1查询的集合运算.sql <span style='color:#111;'> 257B </span>","children":null,"spread":false},{"title":"2.4带in的范围查询.sql <span style='color:#111;'> 192B </span>","children":null,"spread":false},{"title":"1.2基本构造字段查询.sql <span style='color:#111;'> 77B </span>","children":null,"spread":false},{"title":"2.3带between的范围查询.sql <span style='color:#111;'> 160B </span>","children":null,"spread":false},{"title":"5.1嵌套查询.sql <span style='color:#111;'> 208B </span>","children":null,"spread":false},{"title":"1.1基本指定字段查询.sql <span style='color:#111;'> 62B </span>","children":null,"spread":false},{"title":"实验九：查询的创建和使用.doc <span style='color:#111;'> 559.00KB </span>","children":null,"spread":false},{"title":"2.2带WHERE子句的条件查询.sql <span style='color:#111;'> 118B </span>","children":null,"spread":false},{"title":"4.1连接查询.sql <span style='color:#111;'> 181B </span>","children":null,"spread":false},{"title":"3.1带like的匹配查询.sql <span style='color:#111;'> 120B </span>","children":null,"spread":false}],"spread":false}],"spread":true}]