CREATE PROCEDURE GetCustomerOrders (@CustomerID INT)
AS
BEGIN
SELECT * FROM Orders WHERE CustomerID = @CustomerID;
END
CREATE PROCEDURE AddNewProduct (@ProductName VARCHAR(50), @Price DECIMAL(10,2), @Stock INT)
AS
BEGIN
INSERT INTO Products (ProductName, Price, Stock) VALUES (@ProductName, @Price, @Stock);
END
CREATE PROCEDURE UpdateProductPrice (@ProductID INT, @NewPrice DECIMAL(10,2))
AS
BEGIN
UPDATE Products SET Price = @NewPrice WHERE ProductID = @ProductID;
END