如果参数为空,where 语句中的 TSQL Case
我有一个给我带来很多困难的 SP.
I have a SP that gives me a lot of hard times.
sp 得到两个参数@madeByUserId 和@reportedByUserId.我想要类似的东西:
The sp gets a two parameters @madeByUserId and @reportedByUserId. I want to have something like:
select * from table
where MadeByUserId = @madeByUserId (if(@reportedByUserID != null) and ReportedByUserID = @reportedByUserID)
基本上我想在 where 子句中包含另一个基于 @reportedByUserId 的空/非空状态的过滤条件
Basically I want to make a case in the where clause to include another filter condition based of the null/not null state of the @reportedByUserId
这可能吗?
非常感谢,拉杜
推荐答案
尝试:
select * from table
where MadeByUserId = @madeByUserId
AND (@reportedByUserID IS null OR ReportedByUserID = @reportedByUserID)
相关文章