select id,substring(Memo,charindex('数量',Memo)+3,len(Memo)-charindex('数量',Memo)) from trace where Memo like '%退货%'
转载于:https://www.cnblogs.com/smartsensor/p/10754589.html
select id,substring(Memo,charindex('数量',Memo)+3,len(Memo)-charindex('数量',Memo)) from trace where Memo like '%退货%'
转载于:https://www.cnblogs.com/smartsensor/p/10754589.html