using if statement in stored procedure in sql

Question

I have a stored procedure that is returning me some records. Now I want to change the condition on which the records are being shown on the basis of a condition

select * from table
WHERE cond1 = c1
AND cond2 = c2

basically I want a structure like this

if(Val1= Val2) then  
select * from table
WHERE cond1 = c1
AND cond2 = c2
AND cond3 = c3
else
select * from table
WHERE cond1 = c1
AND cond2 = c2

Since the stored proc is huge and I can't change too much in that so I can only change the where condition using if statement.

Its simple I need to embed a condition in where clause if a particular value satisfy the condition.. kind of dynamically editing the where clause in stored procedure — Gautam
– Gautam, Commented Dec 18, 2012 at 7:19

Damien_The_Unbeliever · Accepted Answer · 2012-12-18 07:29:01Z

3

Just include the condition in your where clause:

select * from table
WHERE cond1 = c1
AND cond2 = c2
AND (Val1 <> Val2 OR cond3 = c3)

If this structure keeps expanding - maybe you're doing some form of search with different possible parameters - it's worth reading Erland Sommarskog's Dynamic Search conditions in T-SQL

answered Dec 18, 2012 at 7:29

Damien_The_Unbeliever

241k28 gold badges357 silver badges469 bronze badges

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

2 Comments

Mr Moose Over a year ago

+1 - I don't know who Erland is, but he has some pretty useful material.

Damien_The_Unbeliever Over a year ago

@MrMoose - I've never seen Erland on here. He used to be quite active on the usenet groups (e.g. microsoft.public.sqlserver.programming), and his work is still superbly researched.

Kapil Khandelwal · Accepted Answer · 2012-12-18 07:15:30Z

0

Try this:

IF Val1 = Val2 
BEGIN

END
ELSE
BEGIN

END

answered Dec 18, 2012 at 7:15

Kapil Khandelwal

16.2k3 gold badges49 silver badges55 bronze badges

2 Comments

Gautam Over a year ago

will it be working within where clause? I mean I just need to add an extra "AND" condition in the where clause3

Raj Over a year ago

If you are wanting to change just the WHERE clause based on the variable values, then you will need to use Dynamic SQL. I mean you cannot simply code - Select * from Table IF var1=var2 WHERE...

Collectives™ on Stack Overflow

using if statement in stored procedure in sql

2 Answers 2

2 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Related