upitemgetlist_benchmark.sql

基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及开发效率上明显优于基于SUN J2EE框架开发的PETSHOP. 项目包括所有源码及数据库建库脚本,是不错的学习 AS

/******************************************************************************
**        File: upItemGetList_Benchmark.sql
**        Name: upItemGetList Stored Procedure
**        Desc: Gets the list of items for a specific product type. 
**              This was modified to return the TOP 25 results for the 
**              benchmarking.
**
**        Date: 11/6/2001
**
*******************************************************************************/

ALTER PROCEDURE upItemGetList
(
    @prodid              varchar(10)
)
AS

    SELECT TOP 25 itemid, listprice, attr1
    FROM Item
    WHERE productid = @prodid