Control flow in T-SQL SP using IF..ELSE IF - are there other ways?
sql, sql-server, sql-server-2008, t-sql
Solution
IF...ELSE... is pretty much what we've got in T-SQL. There is nothing like structured programming's CASE statement. If you have an extended set of ...ELSE IF...s to deal with, be sure to include BEGIN...END for each block to keep things clear, and always remember, consistent indentation is your friend!
Problem
I need to branch my T-SQL stored procedure (MS SQL 2008) control flow to a number of directions: ``` 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 ``` Is there any other ways? For example, in `C#` I shoud use `switch-case` block.