📄 upproductsearch_benchmark.sql
字号:
/******************************************************************************
** File: upProductSearch_Benchmark.sql
** Name: upProductSearch Stored Procedure
** Desc: Basic catalog search. This was modified to
** return the TOP 25 results for the benchmarking.
**
** Date: 11/9/2001
**
*******************************************************************************/
ALTER PROCEDURE upProductSearch
(
@Search nvarchar(255)
)
AS
DECLARE @_name varchar(50)
SET @_name = '%' + @Search + '%'
SELECT TOP 25 productid, [name], descn
FROM Product
WHERE
(
--search the product name field
[name] like (@_name)
OR
-- search the products category field
category like (@_name)
)
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -