level 1
帅似倾国
楼主
SELECT deliverytaskid,deliverytaskname,Orgquantity,varietyquantity,theoryquantity,theoryweight,realityquantity,realityweight,deliverydate
FROM dispatchcollect
WHERE LEFT(CONVERT(varchar(10) ,deliverydate,23),LEN(:date)) = :date AND
LEFT(deliverytaskid,LEN(:deliverytaskid)) = :deliverytaskid
2019年01月07日 03点01分
1
FROM dispatchcollect
WHERE LEFT(CONVERT(varchar(10) ,deliverydate,23),LEN(:date)) = :date AND
LEFT(deliverytaskid,LEN(:deliverytaskid)) = :deliverytaskid