title: Control flow in T-SQL SP using IF..ELSE IF - are there other ways?
body: <p>I need to branch my T-SQL stored procedure (MS SQL 2008) control flow to a number of directions:</p>
  
  <pre><code>CREATE PROCEDURE [fooBar]
     @inputParam INT
  AS
  BEGIN
    IF @inputParam = 1
    BEGIN
      ...
    END
    ELSE IF @inputParam = 3
    BEGIN
      ...
    END
    ELSE IF @inputParam = 3
    BEGIN
      ...
    END
  END
  </code></pre>
  
  <p>Is there any other ways? For example, in <code>C#</code> I shoud use <code>switch-case</code> block.</p>