日期:2014-05-18 浏览次数:20654 次
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 --没有在查询分析器里写..直接在这写了..大致就这个思路