34,576
社区成员
发帖
与我相关
我的任务
分享
update fs_ns_news
set savenewspath = '/'+right(replace(savenewspath ,'/','-'),len(savenewspath ) - 1)
where id > 0
修改下
update T set T.savenewspath =Covert( varchar(30),T2.savenewspath,120) from table T ,table T2 where T.主键=T2.主键
update T set savenewspath =Covert(savenewspath,,120) from table T ,tableT2 where T.主键=T2.主键