SQL 拼接字符串参数报错转换成数据类型 int 时失败
set @sql='insert into '+@ltable+'(ywyID,ywymc,bmmc,deptpath,sjbmmc,iysSum) select ywyID,ywymc,bmmc,deptpath,sjbmmc,sum(iSum) iSum from (select ywyID,ywymc,bmmc,deptpath,sjbmmc,isnull(ycye,0) iSum from '+@TEMP_ysmxtb+' where xdqr<'''+@nextdate+''' union all select ywyID,ywymc,bmmc,deptpath,sjbmmc,isnull(bqxs,0) iSum from '+@TEMP_ysmxtb set @strSql=' where zq =0 and year(CONVERT(datetime,xdqr))= '+CONVERT(varchar(4),@iyear)+' and month(CONVERT(datetime,xdqr))='+CONVERT(varchar(4),@imonth)+') a group by ywyID,ywymc,bmmc,deptpath,sjbmmc' print (@sql+@strSql) exec(@sql+@strSql)
--@iyear和@imonth传的都是int 拼字符串时,必须先转成字符串,不然会报错
--and year(CONVERT(datetime,xdqr))='+@iyear+' and month(CONVERT(datetime,xdqr))='+@imonth+'