＋设为首页 ＋添加到收藏夹
select news_title from tbl_news where news_title like %/?%
请问如何用T-sql成批替换掉news_title里的“？”
在线等待中。。。
update tbl_news set news_title=replace(news_title,?,!)
将?替换成!
replace(news_title ,?, )
update tabl_news set news_title = replace(news_title, ?, )
or
select replace(news_title, ?, ) from tbl_news where news_title like %/?%
replace(news_title ,?, )
同意
如果要将?去掉,就如下:
update tbl_news set news_title=replace(news_title,?,)
