Using parameters with stored procedures

- Okay, create a new query and enter the code…as you see it in the query editor here.…Okay, let's take a look at that code that we just looked at…on the slide and we'll see it execute.…Again, this is straight out of MSDN.…So, we're creating a procedure with two parameters.…And then we're setting the code.…And then we're going to Execute it.…So the first thing we're going to do…is create the Store Procedure.…And let's go and see what happened.…There it is and we'll examine that again in just a second.…

Now you see we can execute the code…and it returns Pilar Ackerman.…Or the other options which will work just fine.…So let's come over here and right-click this Store Procedure…and if we go Modify, you see now…here's my Store Procedure is up…and this auto-procedure and there's my modification.…Or if I right-click it again, Script, Store Procedure As,…and this is the standard stuff I can do,…Drop and Create to, New Query Editor.…

Now this will drop the Store Procedure…and then allow me to go in and edit it.…I point that out because this is, by far, the easiest way…