基于存储过程参数的条件 where 子句? [英] conditional where clause based on a stored procedure parameter?

问题描述

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

I have a SQL Server 2005 stored proc that takes a parameter: @includeClosedProjects.

我想根据这个参数控制一个 WHERE 子句.

There's a WHERE clause that I want to control based on this param.

create proc sel_projects
(@incClosedRel int = 1)
as

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

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

I want to get all projects (exclude the where clause), when @incClosedRel =1. Otherwise, include the where clause.

推荐答案

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

这篇关于基于存储过程参数的条件 where 子句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！