在B/S模式下，通常Web利用动态SQL语句或存储过程查询数据 库，本文对使用动态SQL语句和存储过程进行测试和比较，分析使用这两种方法的查询效率 及对Web服务器和数据库服务器负载的影响，对实际工程设计具有一定的参考价值.
In B/S model, there are two methods to query database. This paper use dynamic SQL to compare with store procedure, analysing the query efficiency of the two methods and the overload of Web server and sql server . It has value to project design.
[1] Meier J D. Top Ten Tips:Accessing SQL Through ADO and ASP. Http://msdn.microsoft.com/library/default.asp? [OL]. URL=/library/periodic/period98/ado.htm 1998.
[2] Microsoft. Microsoft SQL Server 6.5 程序员指南 [M]. 北京:科学出版社 1997.
[3] Meier J D. I Cannot Stress It Enough--Load Test Your ASP Applica tion [OL]. http://msdn.microsoft.com/siteguide/write-us.asp?author=J%2ED%2E+Meier&area=Server+Technologies 2000.
