1ALTER PROCEDURE uspFindProducts(@min_list_price AS DECIMAL)
2AS
3BEGIN
4 SELECT
5 product_name,
6 list_price
7 FROM
8 production.products
9 WHERE
10 list_price >= @min_list_price
11 ORDER BY
12 list_price;
13END;
14Code language: SQL (Structured Query Language) (sql)