存储过程参数查询

供参考

((mesReceive.xDateTime >= convert(datetime, @ReceiveDateFrom, 105) or isnull(@ReceiveDateFrom,'')='' or @ReceiveDateFrom ='-1') 
AND (mesReceive.xDateTime < (convert(datetime, @ReceiveDateTo, 105)+1) or isnull(@ReceiveDateTo,'')='' or @ReceiveDateTo ='-1'))

 

posted on 2015-03-10 17:51  风云01  阅读(184)  评论(0)    收藏  举报