Хранимая процедура для AdventureWorks
 USE AdventureWorks
GO
CREATE PROCEDURE usp_Product_UpdatePrice
(
   @ProductID int,
   @ListPrice money
)
AS
UPDATE Production.Product
SET ListPrice = @ListPrice
WHERE ProductID = @ProductID;
GO
CREATE PROCEDURE usp_Product_SelectPrice
AS
SELECT TOP 10 P.ProductID, P.ListPrice
FROM Production.Product AS P
WHERE P.ProductID > 440
ORDER BY P.ProductID