1.如何接收为空的参数。如果参数的值为空，则and ias.origin='' "，如果参数的值不为空，则 and ias.origin=?
="select * from itsm_assets ias,itsm_department ide
where ias.del = '0'
and ias.department=ide.id
and ide.name=?"
+if((@origin==null or @origin=='')," and ias.origin='' "," and ias.origin=? ") +
"order by ias.date_recorded desc"
posted on 2011-11-29 15:06
kxbin 阅读(1000)
评论(0) 编辑 收藏 所属分类:
皕杰报表