34,590
社区成员
发帖
与我相关
我的任务
分享
update a set b = substring(b,1,2) + 'html'
update a
set b = replace(b, '.html', '.aspx'
where right(b,5)='.html'
update A set b = REPLACE(b,'html','aspx')
where LEFT(b,4) ='html'
update A set b = REPLACE(b,'html','aspx')
where LEFT(book09,4) ='html'