title: optional parameters in SQL Server stored proc?
body: <p>I'm writing some stored procs in SQL Server 2008, and wondered if the concept of optional input parameters is possible here?  </p>
  
  <p>I suppose I could always pass in NULL for parameters I don't want to use, check the value in the stored proc, then take things from there, but I was interested if the concept is available here.  Thanks!  </p>