摘要
在WEB应用系统中经常要处理大量数据,因此WEB服务器就要经常响应大量数据请求。数据查询和更新操作的效率通常成为制约WEB应用系统性能的因素。在WEB软件开发过程中应用存储过程能较好的解决数据查询、更新操作效率低的问题。同时存储过程的应用对软件的安全性、软件的复用性和软件开发效率等方面都具有影响。该文探讨了SQL Server数据库存储过程的应用优势,最后基于ASP技术实现了一个应用实例。
Large amounts of data often have to be deal with in WEB applications,so WEB server often has the need to respond a large amount of data requests.The efficiency of data query and operations update is usually the factors restricting the performance of Web applica tions.The application of the stored procedure during WEB software development process solve problem of the low operating efficiency of data query & data update.At the same time the application of the stored procedure has an impact for software security,reuse and develop ment efficiency.This paper discusses the application advantages of the SQL Server database stored procedures,and also gives a real sample.
出处
《电脑知识与技术（过刊）》
2012年第3X期1738-1740,共3页
Computer Knowledge and Technology
关键词
关系数据库
SQL
存储过程
WEB应用
软件开发
relational database
SQL
stored procedure
WEB application
software development
