select replace(TableName,'?','') from TableInfo
--TableInfo表名,TableName含?的字段名
update TableInfo set TableName=replace(TableName,'?','')
sql:处理表中某字段的数据含有?字符
最新推荐文章于 2021-07-28 23:53:51 发布
select replace(TableName,'?','') from TableInfo
--TableInfo表名,TableName含?的字段名
update TableInfo set TableName=replace(TableName,'?','')