--select * from update mactiondef set requesturl=STUFF ( requesturl , 1 , 19 ,'' ) where requesturl like 'ptrexpensetraining/%'; 改完别忘了重启服务,