急求一个SQL命令,在线等待~~~~~

[yesun]

一个 SQL 命令。
怎么把表fs_ns_news 的字段savenewspath 的格式修改一下
例如原来的格式为/2005-1/10
现在要修改成/2005-1-10
也就是把第二个出现的 / 改成 -
数据大概有7000条
update fs_ns_news set savenewspath (这里不会) where id > 0

[-狙击手-]

update fs_ns_news
set savenewspath = left(savenewspath ,Instr(2,savenewspath ,'/') -1 ) +'-'+ right(savenewspath ,len(savenewspath ) - Instr(2,savenewspath ,'/'))
where id > 0

[懒牛科技]

update T set savenewspath =Covert(savenewspath,,120) from table T ,tableT2 where T.主键=T2.主键

试试

[-狙击手-]

update fs_ns_news
set savenewspath = '/'+stuff(replace(savenewspath ,'/','-'),1,1,'')
where id > 0

[yesun]

回答楼上的 [Microsoft][ODBC Microsoft Access Driver] 表达式中 'stuff' 函数未定义。
1楼的我看不懂。T2是什么。我是菜鸟啊。

[懒牛科技]

修改下

update T set T.savenewspath =Covert( varchar(30),T2.savenewspath,120) from table T ,table T2 where T.主键=T2.主键

[-狙击手-]

update fs_ns_news 
set savenewspath  = '/'+right(replace(savenewspath ,'/','-'),len(savenewspath ) - 1) 
where id > 0