CREATE PROCEDURE usp_myProcedure
  @name varchar(100) = '',@surname varchar(100) = '',@address varchar(100) = ''
AS
BEGIN
...
END

从T-sql调用它：

exec usp_myProcedure @name='John',@surname = 'Doe';
exec usp_myProcedure @name='Jane',@address = '123 Anystreet';

从C#调用它：

sqlCommand cmd = new sqlCommand('usp_MyProcedure',...);
cmd.CommandType = commandtype.StoredProcedure;
cmd.Parameters.AddWithValue('@name','John');
cmd.Parameters.AddWithValue('@surname','Doe');