Specify a parameter name using an @ sign as the first character. Parameters are local to the procedure. The same parameter names can be used in other procedures. By default, parameters can take the place only of constants; they cannot be used in place of table names, column names, or the names of other database objects.
Syntax
Example
Once the stored procedure is created, you can simply execute this procedure by using the following syntax. The results will look something like this:
