差别很大？ [英] the big difference?

问题描述

ls_filter = "v_car_truck_bus_trailer_materiaal_id = " +string(ll_materiaalid) +" AND ('" +  string(idt_referentiedatum,"yyyy-mm-dd") + "' > 'dt_geldigvan' OR IsNull ('dt_geldigvan')) AND ( '" +  string(idt_referentiedatum,"yyyy-mm-dd") + "' <  'dt_geldigtot' or IsNull ('dt_geldigtot'))"

我们上面的filterstring和下面的查询之间有什么区别？

whats the difference between the filterstring above and the query below?

select kentekennummer, p.personeelsnr, bp.dt_geldigvan, bp.dt_geldigtot,vctbt.materiaal_id
from gloriant.v_car_truck_bus_trailer as vctbt
left join gloriant.bestemmingsgoed_personeel as bp on bp.bestemmingsgoed_id = vctbt.bestemmingsgoed_id
left join gloriant.personeel as p on bp.personeel_id = p.id
where vctbt.dossier_id = 1
and materiaal_id = @index
and( '2012-12-25' > dt_geldigvan or dt_geldigvan is null)
and ( '2012-12-25' < dt_geldigtot or dt_geldigtot is null)

他们应该这样做..

they should do the same..

推荐答案

过滤器在最基本的层面上是不同的，因此它们不是相同的。在代码中发出SQL以查看字符串mashing正在创建的内容，以查看它的不同之处。此外，这是可怕的，不要这样做。如果必须使用mash SQL字符串，请使用paramaterised查询。

The filters are different, on the most basic level, so they are not 'the same'. Emit your SQL in code to see what your string mashing is creating, to see how it differs. Also, this is horrible, don't do it. Use paramaterised queries if you must string mash SQL.

这篇关于差别很大？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！