upproductgetlist_benchmark.sql

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

/******************************************************************************
**        File: upProductGetList_Benchmark.sql
**        Name: upProductGetList Stored Procedure
**        Desc: Gets the list of products via the selected category.
**              This was modified to return the TOP 50 results for 
**              the benchmarking.
**
**        Date: 11/6/2001
**
*******************************************************************************/

ALTER PROCEDURE upProductGetList
(
	    @cat_id              char(10)
)
AS

    SELECT TOP 50 productid, name
    FROM Product
    WHERE category = @cat_id
    ORDER BY name