Parameter returned from stored procedure

[VBAHole22]

I know there is a way to get a parameter back out of a stored procedure I just don't have the sin tax right. Can anyone help me out?


Alter Procedure ReturnIDfromCommonName

@COMMON_NAME varchar(50),
@ID char(6) OUTPUT
As


SELECT @ID =BOVA
FROM BOVA_TAXONOMY
WHERE COMMON_NAME = @COMMON_NAME


/* set nocount on */
return

 

[TheBugSlayer]

VBAHole22,
check SQL Server Books Online under "Returning Data Using OUTPUT Parameters".

The syntax is something like:

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

You would call it like this:

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

And use it like this:

PRINT 'Sales for "Sushi, Anyone?": ' + convert(varchar(6),@ytd_sales_for_title)
GO

I hope this helps.