upitemgetlist_benchmark.sql

来自「基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及」· SQL 代码 · 共 20 行

/******************************************************************************
**        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