Using input and output parameters

Now I'd like to talk about sending input parameters and returning output…parameters from a stored procedure.…These are optional.…We have worked with stored procedures thus far without working with parameters,…so they are optional.…I have some code on the screen.…It's available in our exercise files.…It basically alters the stored procedure and then executes the stored procedure.…So I am going to alter the stored procedure to include a 1 input parameter for now.…I do that by creating some parentheses.…

We will need to put all of our parameters in parentheses.…Then I need to give the parameter a name.…And remember, in SQL Server, variable names always start with the at sign, and…beyond that, you can name it almost anything you would like to name it.…We will also need to declare what datatype we're going to use.…Any of the typical SQL Server datatypes are in play, so for example, integer,…varchar, datetime, all of those are perfectly valid.…So I will declare this one as an integer.…

So we're going to alter this procedure to now accept one parameter.…