conditions in where clause

Question

0.00/5 (No votes)

See more:

I want the following query to return records according to @date and @abc passed.If i did not pass any value for param @abc then query should just consider the date conndition and return records according to that.what changes to do in following query?
at present i have the following query..
select * from table where date=@date and abc=@abc

Posted 31-Jan-14 22:38pm

pwavell

Add a Solution

3 solutions

Solution 2

You should check such a a condition in your code and execute a different query, namely

SQL

select * from table where date=@date

for the purpose of ignoring the 'empty' abc parameter.

Posted 31-Jan-14 22:51pm

CPallini

Solution 4

You can use if...else... condition to check whether it is having data or not.

if @date and @abc is not null
begin
    "Your select statement" Where date=@date and abc=@abc
end
if @date is not null and @abc is null
begin
    "Your select statement" Where date=@date 
end
if @date is null and @abc is not null
begin
    "Your select statement" Where abc=@abc
end

Posted 2-Dec-15 22:37pm

Bhavikkumar Chaudhari

Comments

CHill60 4-Dec-15 3:55am

Question was answered correctly (and answer accepted) nearly 2 years ago.
This solution is not just very poor but does not actually answer the original question as asked

Bhavikkumar Chaudhari 4-Dec-15 6:50am

Thanks...!!! :)

That make sense.

Add a Solution

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

OriginalGriff · Accepted Answer · 2014-01-31T22:50:00

Solution 1

Try:

SQL

SELECT * FROM table WHERE date=@date AND (@abc IS NULL OR abc=@abc)

Posted 31-Jan-14 22:50pm

OriginalGriff

conditions in where clause

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

conditions in where clause

3 solutions

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us