SQL Server存储过程在Delphi开发环境下的应用  

Application of SQL Server Stored Procedure in Delphi

作　　者：卢向华[1] 张松敏[1] 

机构地区：[1]洛阳工业高等专科学校计算机系,河南洛阳471003

出　　处：《洛阳工业高等专科学校学报》2006年第5期29-31,共3页Journal of Luoyang Technology College

摘　　要：Delphi在数据库应用开发方面虽然具有强大的功能,但是直接利用它提供的数据库操作组件开发的应用系统性能不高,若在Delphi中使用存储过程,则可以提高应用程序的执行效率。本文主要介绍用Delphi开发基于Client/Server模式的数据库管理系统中使用存储过程的优点及Delphi调用SQLServer2000存储过程的方法;并通过实例给出动态调用存储过程的步骤和方法。Dephi has powerful functions on the Database development, however, the database application system can not gain high performance if the database components provided by Delphi are used to develop application directly. The performancc efficiency of the application can be improved, if we use the stored procedure in Dephi. This paper mainly introduces the virtues of using stored procedure in the DBMS based on Client/Server structure developed by Delphi and the methods which are used to call the stored procedure by Dephi in SOL Server 2000. And then it presents the processes and methods of calling the stored procedure dynamically by some examples.

关 键 词：存储过程 参数 组件 

分 类 号：TP319[自动化与计算机技术—计算机软件与理论]