Tsql翻译

Question

假设我有一张这样的桌子

Id | IsActive
1  | True
2  | False

我想搜索处于活动状态、非活动状态或两者都有的项目

我想问一个问题

声明@ActiveState位

Select * from myTable where IsActive...

在我的where子句中，我希望有这样的内容

if(@ActiveState != null)
    myTable.IsActive == @ActiveState
else
    myTable.ActiveState == true || myTable.ActiveState == false

但是我找不到在同一where子句上这样做的方法

tks

Answer 1

select * from myTable where @ActiveState is null or IsActive = @ActiveState

Answer 2

WHERE myTable.IsActive  = @ActiveState OR @ActiveState IS NULL

Answer 3

Where IsActive = IsNull(@ActiveState, IsActive)

或

Where IsActive = Coalesce(@ActiveState, IsActive)