22,209
社区成员
发帖
与我相关
我的任务
分享
delete from T_MeterOrigValue
where F_OrigValueID in (select F_OrigValueID from T_MeterOrigValue_bak);
--封装到,try catch里面
begin try
begin tran
insert into T_MeterOrigValue_bak
select *
from T_MeterOrigValue
where (F_OrigValueID like '350100A100%' or F_OrigErrCode<>'A');
commit tran
end try
begin catch
select error_number()
rollback tran
end catch
--没有在查询分析器里写..直接在这写了..大致就这个思路
--...数据处理过程
begin transaction -- 开始事务
insert into T_MeterOrigValue_bak
select *
from T_MeterOrigValue
where (F_OrigValueID like '350100A100%' or F_OrigErrCode<>'A');
IF @@ERROR <> 0
rollback transaction -- 如果插入出错,回滚事务
else
commit transaction; -- 插入成功,提交事务
delete from T_MeterOrigValue
where F_OrigValueID in (select F_OrigValueID from T_MeterOrigValue_bak);