update rpt_table_target a set a.reprownum = (select b.reprownum+1 from rpt_table_target b where b.tabname='S4500' and b.reprownum >'10' )
where a.tabname ='S4500' and a.reprownum > '10'
and exists (select a.reprownum from rpt_table_target a where a.tabname='S4500' and a.reprownum >'10')
无非就是想在 修改和增加的同时 变更此 > 此数据的 序列号+1
使序列号 保持 不重复的状态累积...SQL 更新不明白了...求教育啊
set a.reprownum = a.reprownum - 1
where a.tabname = 'S4500'
and a.reprownum > '1'
and exists (select a.reprownum
from rpt_table_target a
where a.tabname = 'S4500'
and a.reprownum > '1')
这么一写 就好了...哎...
where a.tabname ='S4500' and a.reprownum > '10' 这样不就行了吗?