一．　　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.