sql - 基于存储过程参数的条件 where 子句？

Question

我有一个 SQL Server 2005 存储过程，它带有一个参数:@includeClosedProjects .

有一个 WHERE我想根据这个参数控制的子句。

create proc sel_projects
(@incClosedRel int = 1)
as

SELECT projectId, projectName
FROM project
WHERE CompletionStatusCID NOT IN (34, 35) <-- controlled by @incClosedRel 

我想获取所有项目(不包括 where 子句)，when @incClosedRel =1 .
否则，包括 where 子句。

Answer 1

SELECT projectId, projectName
FROM project
WHERE CompletionStatusCID NOT IN (34, 35) 
    Or @incClosedRel = 1