细化解析：如何使用OUTPUT参数返回数据

CREATE PROCEDURE get_sales_for_title
@title varchar(80),   -- This is the input parameter.
@ytd_sales int OUTPUT -- This is the output parameter.
AS  

-- Get the sales for the specified title and 
-- assign it to the output parameter.
SELECT @ytd_sales = ytd_sales
FROM titles
WHERE title = @title

RETURN
GO

-- Declare the 
variable to receive the output value of the procedure.
DECLARE @ytd_sales_for_title int

-- Execute the procedure with a title_id value
-- and save the output value in a variable.

EXECUTE get_sales_for_title
"Sushi, Anyone?", @ytd_sales = @ytd_sales_for_title OUTPUT 

-- Display the value returned by the procedure.
PRINT 'Sales for "Sushi, Anyone?": 
' +    convert(varchar(6),@ytd_sales_for_title)
GO

Sales for "Sushi, Anyone?": 4095