CREATE PROCEDURE TotalSales
@year smallint , @total money OUTPUT AS SELECT @total=SUM(Amount) FROM Orders WHERE DATEPART(yy,OrderDate) = @year RETURN @@ERRPR
======================================================
DECLARE @err int , @sum money
EXEC @err = TotalSales , @year = 2001 , @total = @sum
OUTPUT
IF @err = 0 PRINT "Total is " + STR (@sum)
ELSE PRINT "Error occurred"