Design and Implementation of the Accounting System for Query & Statistics Based on Stored Procedure
Ke Zeng · Modern Electronic Technique · 2005
By means of the stored procedure to encapsulate database operation,avoiding redundancy encoding so that developing efficiency can be greatly improved.First,this paper analyses the brief theory and method of the stored procedure.Then,it discusses design thoughtway and encoding implementation of the stored procedure by Sybase SQL Server in accounting system for query statistics.At last,the optimize of stored procedure and application of extended stored procedure are also indicated in the system.