- 創建一個簡單的存儲過程，返回所有顧客的數量：
CREATE PROCEDURE GetCustomerCount
AS
BEGIN
SELECT COUNT(*) AS CustomerCount FROM Customers;
END
- 創建一個存儲過程，根據給定的國家參數返回該國家的所有顧客：
CREATE PROCEDURE GetCustomersByCountry
@Country NVARCHAR(50)
AS
BEGIN
SELECT * FROM Customers WHERE Country = @Country;
END
- 創建一個存儲過程，將給定的訂單號參數作為輸入，并返回該訂單的詳細信息：
CREATE PROCEDURE GetOrderDetails
@OrderID INT
AS
BEGIN
SELECT * FROM Orders WHERE OrderID = @OrderID;
END
- 創建一個存儲過程，將給定的產品類別參數作為輸入，并返回該類別中所有產品的數量和平均價格：
CREATE PROCEDURE GetProductStats
@CategoryID INT
AS
BEGIN
SELECT COUNT(*) AS ProductCount, AVG(Price) AS AveragePrice
FROM Products
WHERE CategoryID = @CategoryID;
END
