What is the difference between IF-ELSE and SWITCH?

Posted by ahmed on Stack Overflow See other posts from Stack Overflow or by ahmed
Published on 2009-03-25T08:16:44Z Indexed on 2010/05/15 3:04 UTC
Read the original article Hit count: 311

Filed under:

if-statement

|

switch-statement

|

language-agnostic

Can someone please explain this to me?

© Stack Overflow or respective owner

Related posts about if-statement

Performance of if statement versus switch statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Everyone, I have an if statement with 16 cases (I am checking the state of four boolean variables). Would there be any value in trying to implement this differently, with nested switch statements perhaps? What is the actual performance gain of a switch statement over an if statement? Thanks! >>> More
C# SQL Statement transformed TO LINQ how can i translate this statement to a working linq

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having trouble with this I have 3 Data tables i use over and over again which are cached I would like to write a LINQ statement which would do the following is this possible? T-SQL VERSION: SELECT P.[CID],P.[AID] ,B.[AID], B.[Data], B.[Status], B.[Language] FROM MY_TABLE_1 P JOIN ( … >>> More
ms sql use like statement result in if statement

as seen on Stack Overflow - Search for 'Stack Overflow'
declare @d varchar set @d = 'No filter' if (@d like 'No filter') BEGIN select 'matched' end else begin select 'not matched' end the result of above is always not matched can anybody tell me why and how can I use the like or '=' result in my stored procedure. thanks >>> More
Using a Case statement within the values section of an Insert statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Please forgive my ignorance and poor SQL programming skills but I am normally a basic SQL developer. I need to create a trigger off the insertion of data in one table to insert different data into another table. Within this trigger I need to insert certain data into the new table based upon values… >>> More
How to join dynamic sql statement in variable with normal statement

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a quite complicated query which will by built up dynamically and is saved in a variable. As second part i have another normal query and i'd like to make an inner join between these both. To make it a little more easier here is a little example to illustrate my problem. For this little example… >>> More

Related posts about switch-statement

Is a switch statement the fastest way to implement operator interpretation in Java

as seen on Stack Overflow - Search for 'Stack Overflow'
Is a switch statement the fastest way to implement operator interpretation in Java public boolean accept(final int op, int x, int val) { switch (op) { case OP_EQUAL: return x == val; case OP_BIGGER: return x > val; case OP_SMALLER: … >>> More
C++ Switch Statement Case Error

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm programming a simple text-based RPG using a switch statement for a game loop. The program works fine until I attempt to add another case statement, at which point it gives me the following three errors: "jump to case label" (error occurs at the line of the newly added case), and two "crosses initialization… >>> More
Better Alternative to Case Statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I currently have a switch statement that runs around 300 odd lines. I know this is not as giant as it can get, but I'm sure there's a better way to handle this. The switch statement takes an Enum that is used to determine certain properties that pertain to logging. Right now the problem… >>> More
VS2003 : c# case switch statement...

as seen on Stack Overflow - Search for 'Stack Overflow'
For ScoreOption, I expect to get the following input "A", "B", and T_(state) for example T_NY so.. how can I write case switch statement for third option T_(state) switch(ScoreOption.ToUpper().Trim()) { case "A": .... break; … >>> More
How to simplify this php switch statement?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to change this: // use appropiate lang.xx.php file according to the value of the $lang switch ($_SESSION['lang']) { case 'en': $lang_file = 'lang.en.php'; break; case 'es': $lang_file = 'lang.es.php'; break; case 'zh-tw': $lang_file = 'lang.zh-tw.php'; break; case… >>> More