Using Parameters in a Stored Procedure 1

[MattN]

Can anyone give me a sample of a very simple stored procedure which uses a parameter i.e. OrderNo

This would be most helpful to get me started. I will figure out the rest.

Kind Regards

MattN

 

[rdl1206]

If you still have the 'pubs' database on your install...

CREATE PROCEDURE byroyalty @percentage int
AS
select au_id from titleauthor
where titleauthor.royaltyper = @percentage


GO

...this stored proc is still there.

Execute the stored proc...

EXEC byroyalty @percentage = 100

 

[MattN]

So simple when you know how.

Now I can progress to the more complex.

Thanks