CREATE PROCEDURE dbo.Foo (
  @Required Int,
  @Optional Int = 0
) AS ...