存储过程是数据库端执行的一组T-SQL语句集合,使用它可以减少网络流量、提高系统性能。本文简要介绍了存储过程的概念、勘探设备管理系统的架构及其主要功能,详细阐述了数据库分页、触发器、动态交叉表等存储过程的开发和应用。%A stored procedure is a group of T-SQL statement executed on the database. Stored procedure can be used for reducing the network flow and improving the system performance. This paper briefly introduced the concept of stored procedure as well as the management system of prospecting equipment and its main functions. Development and application of stored procedure, such as database pagination, trigger and Dynamic Crosstab are described in detail.
展开▼