<div>
yes, both are works. &nbsp;BIG THANKS!!<br />
<br />
Can you please tell me why or how @ordernumber = 0 OR ordernumber = @ordernumber this will work?<br />
<br />
thanks,
</div>


yes, both are works.  BIG THANKS!!

Can you please tell me why or how @ordernumber = 0 OR ordernumber = @ordernumber this will work?

thanks,

<div>
<br />
and(<b>@ordernumber = 0</b> OR ordernumber = @ordernumber )<br />
<br />
if @ordernumber is 0 the the condition always evaluates to true hence you get all the data
</div>



and(@ordernumber = 0 OR ordernumber = @ordernumber )

if @ordernumber is 0 the the condition always evaluates to true hence you get all the data

<div>
<div class="content wysiwyg-content">
I have a store procedure with 1 parameter name ordernumber, when ordernumber = 0, I need to &nbsp;select all the order, or when ordernumber &gt;&nbsp;0 will select that order. &nbsp; <br />
<br />
ex: &nbsp;<br />
<br />
select *<br />
from order <br />
where order_status = 'active'<br />
&nbsp;and ordernumber = @ordernumber<br />
<br />
<br />
what can I do in the where to select all order?<br />
<br />
thanks,
</div>
</div>


I have a store procedure with 1 parameter name ordernumber, when ordernumber = 0, I need to  select all the order, or when ordernumber > 0 will select that order.   

ex:  

select *
from order 
where order_status = 'active'
 and ordernumber = @ordernumber


what can I do in the where to select all order?

thanks,

t-sql store procedure - condition in where

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.