如果参数为空,where 语句中的 TSQL Case

2021-09-10 00:00:00 sql tsql sql-server

我有一个给我带来很多困难的 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)

相关文章