事务控制流程

 1 先提取符合的记录行到临时表
2 统计临时表的count()行数
3 定义局部变量
  declare @tj int
  set @tj = (统计临时表的count()行数)
3 设置 begin transaction tr_insert
3 进行插入语句
4 判断
  if @@ROWCOUNT = @tj
    更新标志
    commit transaction tr_insert
  else
    rollback transaction tr_insert

 

-----------------------------------------------

select * into #T from taba  where bz = '0'
declare @tj int
set @tj = (select count(*) from #T)

begin transaction tr_insert

INSERT INTO tabb(航班名,机场,里程,票价)
SELECT 航班名,机场,里程,票价 FROM #T WHERE bz='0'

if @@ROWCOUNT = @tj
  begin
    update taba set bz='1' from #T,tabb where #T.机场=tabb.机场
    commit transaction tr_insert
  end
else
  begin
  rollback transaction tr_insert
  end

end

drop table #T