The SQL Server Stored Procedure in the Application of WEB Technology
Aijun Zhen · Computer Knowledge and Technology · 2012
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.