If statement in SQL-server

Question

I'm extending a stored procedure and I have to make some code that checks if a row contains some of the following then the SP will stop at the first stip which is this one. The SP contains of 6 steps and this is the first one. Which is used as a controller to see if the row contains some if these. If it's doesent then it should continue to the next step. If it does cointain some of the following then it should leave a notice and not contiune to the next step.

if @action = (select action from dbo.table where action like 'something-%')

if @action = (select action from dbo.table where action like 'something-else%')


if @action = (select action from dbo.table where action like 'something-new%')


if @action = (select action from dbo.table where action like 'something-old%')


if @action = (select action from dbo.table where action like 'something-cool%')

I have the first part need help with the second.

Cheers

Is the next step not a RETURN statement?

Paul Michaels
– Paul Michaels

2013-11-21 09:17:27 +00:00
Commented Nov 21, 2013 at 9:17 — Paul Michaels
– Paul Michaels, Commented Nov 21, 2013 at 9:17
you should use if...else if. Using CASE might be better

Raj
– Raj

2013-11-21 09:17:58 +00:00
Commented Nov 21, 2013 at 9:17 — Raj
– Raj, Commented Nov 21, 2013 at 9:17

Paul Michaels · Accepted Answer · 2013-11-21 09:20:51Z

2

I'd just use RETURN:

if @action = (select action from dbo.table where action like 'something-%') begin
    RETURN;
end

answered Nov 21, 2013 at 9:20

Paul Michaels

16.8k47 gold badges156 silver badges277 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Htoo Myat Aung · Accepted Answer · 2013-11-21 09:21:39Z

0

You can use case statement instead of many if statement.
Hope this example will Help

Simple CASE expression: 
    CASE input_expression 
         WHEN when_expression THEN result_expression [ ...n ] 
         [ ELSE else_result_expression ] 
    END 
    Searched CASE expression:
    CASE
         WHEN Boolean_expression THEN result_expression [ ...n ] 
         [ ELSE else_result_expression ] 
    END

answered Nov 21, 2013 at 9:21

Htoo Myat Aung

6661 gold badge7 silver badges16 bronze badges

1 Comment

Paul Michaels Over a year ago

Given that the results are not necessarily mutually exclusive, would that mean potentially executing all the queries needlessly?

Collectives™ on Stack Overflow

If statement in SQL-server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related