// 查询要复制记录并保存到临时表
select * into #tmp from
OMS_WORK_HOUR_DETAIL
where SID = 'BBW-ZNPT-86f049e1-e463-419d-a402-99bf1a3af588'
// 更新记录
update #tmp set SID = SID + '1',WORK_DATE = WORK_DATE -1
--SELECT * FROM #tmp
// 保存更新后的记录
insert into OMS_WORK_HOUR_DETAIL select * from #tmp