What is Advantages & Disadvantages of using CASE in SQL

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

I Know the Syntax...

CASE column_name
WHEN condition1 THEN result1
WHEN condition2 THEN result2
...
ELSE result
END

i need Advantages & Disadvantages of CASE Expersion

Posted 25-Nov-14 1:16am

Mathivarma

Add a Solution

Comments

E.F. Nijboer 25-Nov-14 7:18am

This sounds like homework and can easily be found using any of the available search engines. This isn't a question for codeproject. What have you tried? Why would you assume advantages? Or why do you suspect disadvantages?

Maciej Los 25-Nov-14 17:02pm

The question makes no sense. We can talk about advantages or disadvantages only in case when there is a comparable object.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-11-25T11:09:00

Solution 1

Please read my comment to the question.

CASE[^] evaluates a list of conditions and returns one of multiple possible result expressions.
When to use CASE? When you want to avoid writing of several IF's.

Posted 25-Nov-14 11:09am

Maciej Los

What is Advantages & Disadvantages of using CASE in SQL

1 solution

Solution 1

Add your solution here

Preview 0

What is Advantages & Disadvantages of using CASE in SQL

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us