Procedure with Parameters « Sequence « SQL Server / T-SQL

1.Parameterization: Make use of a few input parameters to create a new record
2.Supplying Default Values
3.Procedure with two parameters
4.Pass a constant to a function
5.Using a Parameter in a WHERE Clause in a procedure
6.If you had two parameters, you could designate them
7.Stored procedure: accepts a ID, name and city and inserts them as new row
8.Procedure Based on input value
9.Pass in three parameters

10.Create procedure with OUTPUT Parameters
11.Pass variable to procedure output parameters
12.Returning a Computed Value as a Stored Procedure Output Parameter
13.Using output parameter to return Values