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 閱讀(1007)
評論(0) 編輯 收藏 所屬分類:
皕杰報表