How Can I Write Switch Statement In Sql To Avoid Of If Else Statements

Question

0.00/5 (No votes)

See more:

Hi,

In my requirements based on the param i need to get the Procedure name.
So i wish to use Switch statement rather than using of multiple if statements.
(I don't want to prepare a table with paramid,proc name.)
Please let me know SQL supports switch statement if yes what is the syntax.

Thank you.

Posted 8-Sep-15 0:05am

Member 9694841

Add a Solution

Comments

Patrice T 8-Sep-15 6:14am

What about doing basic research by yourself and look at documentation ?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

hypermellow · Answer 1 · 2015-09-08T00:14:00

Solution 1

Hi,

MSSQL's equivalent of switch is it's Case statement.

It's usage is described in the documentation for: CASE (Transact-SQL)[^]

... hope it helps.

Posted 8-Sep-15 0:14am

hypermellow

Schatak · Answer 2 · 2015-09-08T00:16:00

Solution 2

You can use CASE in sql server as per your need.
for example :

SQL

DECLARE @TestVal int
SET @TestVal = 3
SELECT
CASE @TestVal
WHEN 1 THEN 'First'
WHEN 2 THEN 'Second'
WHEN 3 THEN 'Third'
ELSE 'Other'
END

Please go to the link to learn more about case CASE statement in SQL server[^]

Posted 8-Sep-15 0:16am

Schatak