WHERE CLAUSE中的过滤 [英] Filteration in WHERE CLAUSE

问题描述

我的参数是可选的。我可以选择任何参数。请告诉我，语法应该在WHERE条件下使用。



问候

shanif



[edit] Urgency已删除 - OriginalGriff [/ edit]

Hi,

my parameters are optional .i can select any parameters . kindly tel me the syntax should be used in WHERE condition.

Regards
shanif

[edit]Urgency deleted - OriginalGriff[/edit]

推荐答案

SELECT COLUMN_NM FROM TABLE_NM WHERE COLUMN _NM = VALUE ORDER BY COLUMN_NM ASC

SELECT COLUMN_NM FROM TABLE_NM WHERE COLUMN _NM =VALUE ORDER BY COLUMN_NM ASC

好吧，如果我理解你在说什么，那么当你的两个日期值都不为空或者国家值不为空时你只想做WHERE，所以尝试类似：

Well if I understand what you''re saying, then you only want to do the WHERE when either both of your dates values are not null OR the country value is not null, so try something like:

WHERE  ((tm.TrnDteRcvDate != null AND tm.trndtedate != null) 
       AND (CAST(CONVERT(VARCHAR, tm.TrnDteRcvDate, 101) AS DATETIME) 
              BETWEEN '01/19/2010' AND '01/20/2010')
       AND (CAST(CONVERT(VARCHAR,tm.trndtedate,101) AS DATETIME) 
              BETWEEN '1/9/2010' AND '1/9/2010'))
       OR (InvVarCoun != null AND InvVarCoun='United States')

这篇关于WHERE CLAUSE中的过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！