1. use
BETWEEN CONVERT(DATETIME, @日期参数起, 102) AND CONVERT(DATETIME, @日期参数止, 102))and pass @日期参数起 and 日期参数止 into exec2. or change
BETWEEN CONVERT(DATETIME,' + @日期参数起 + ', 102) AND CONVERT(DATETIME, ' + @日期参数止 + ', 102))'
===>
BETWEEN CONVERT(DATETIME,''' + CONVERT(CHAR,@日期参数起,112) + ''', 102) AND CONVERT(DATETIME, ''' + CONVERT(CHAR,@日期参数止,112) + ''', 102))'
BETWEEN CONVERT(DATETIME, @日期参数起, 102) AND CONVERT(DATETIME, @日期参数止, 102))and pass @日期参数起 and 日期参数止 into exec2. or change
BETWEEN CONVERT(DATETIME,' + @日期参数起 + ', 102) AND CONVERT(DATETIME, ' + @日期参数止 + ', 102))'
===>
BETWEEN CONVERT(DATETIME,''' + CONVERT(CHAR,@日期参数起,112) + ''', 102) AND CONVERT(DATETIME, ''' + CONVERT(CHAR,@日期参数止,112) + ''', 102))'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货