SQL有关问题._Sql Server

SQL问题.在线等....
写一储存程序..
在where条件下..
当(Shipper = @Shipper AND [email protected])同时满足的时候
就不运行下面的代码.
[email protected]..

select * from A
where ______________________________________

------解决方案--------------------

SQL code

if not exists(select 1 from a where Shipper = @Shipper AND [email protected])...elseselect * from a where [email protected]
------解决方案--------------------
探讨
写一储存程序..
在where条件下..
当(Shipper = @Shipper AND [email protected])同时满足的时候
就不运行下面的代码.
[email protected]..



select * from A 
where ______________________________________

------解决方案--------------------
加or条件
------解决方案--------------------
探讨
where 后面直接来 if。。？
出错..