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