SQL:哪里 MYID = ANY? [英] SQL: Where MYID = ANY?

问题描述

在 SQL 查询中，包含

In a SQL query, that contains

... WHERE MYID = @1 ....

我必须管理 2 个案例
1) 列上有一个过滤器，@1 将是一个数字 (1,2,X...)

I have to manage 2 cases
1) There is a filter on a column, @1 will be a number (1,2,X...)

2) 该列没有过滤器，@1 将是...?(任何)

2) There is no filter on that column, @1 will be ...? (ANY)

这个任何"(SQL Server 2005)有什么东西吗?

Is there something for this "any" (SQL Server 2005) ?

附注.
显然，我明白我可以删除where".

PS.
Obviously, I understand that I can remove the "where".

PPS.
为了更好地理解，我解释了自己:我在代码中有这个查询，并且想在过滤器打开时传递一个整数作为参数，当我的过滤器关闭时传递某物".

PPS.
I explain myself for better understanding: I have this query in the code, and would like to pass an integer as parameter when the filter is ON, and "something" when my filter is OFF.

if (filterOn)
    GetFoos(fooID);
else
    GetFoos("ANY");

GetFoos(param1): "select * from FOOS where FOOID = {0}", param1

推荐答案

有

"select * from FOO where FOOID = {0}", param

当没有要过滤的参数时，使用 param="FOOID"，这将给出

use param="FOOID" when there is no param to filter, this will give

select * from FOO where FOOID = FOOID // removing the filter

这篇关于SQL:哪里 MYID = ANY?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！