文件名称:实验 6 创建和执行存储过程
介绍说明--下载内容均来自于网络,请自行研究使用
一. 1、创建一个存储过程proc_hub,用来查看“hub”商品的所有订货情况,包括订单号,订货客户的姓名及订货数量等。
2、执行存储过程proc_hub。
3、创建一个带参数的存储过程proc_goods,参数为商品名称,通过该存储过程可查看任何指定商品订单信息。
4、带参数执行该存储过程proc_goods。
5、删除所有新建的存储过程。
-one. One, the creation of a storage process proc_hub, used to watch the "hub" of all goods orders. including orders, customer orders for the names and the amounts of orders. Two, the implementation of stored procedures proc_hub. 3, a set of parameters with the storage process proc_goods, parameters for the trade names, adoption of the storage process can be found on any specified goods orders information. 4, with the implementation of the storage parameters proc_goods process. 5, delete all the new storage process.
2、执行存储过程proc_hub。
3、创建一个带参数的存储过程proc_goods,参数为商品名称,通过该存储过程可查看任何指定商品订单信息。
4、带参数执行该存储过程proc_goods。
5、删除所有新建的存储过程。
-one. One, the creation of a storage process proc_hub, used to watch the "hub" of all goods orders. including orders, customer orders for the names and the amounts of orders. Two, the implementation of stored procedures proc_hub. 3, a set of parameters with the storage process proc_goods, parameters for the trade names, adoption of the storage process can be found on any specified goods orders information. 4, with the implementation of the storage parameters proc_goods process. 5, delete all the new storage process.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
压缩包 : 77433639实验 6 创建和执行存储过程.rar 列表 实验 6 创建和执行存储过程.doc