每次select完一个语句用下面语句判断 select col.... from table1 where () if @@error<>0 begin set @errNum=1 goto errHandle endselect col.... from table2 where () if @@error<>0 begin set @errNum=2 goto errHandle endselect 0 return errHandle: select @errNum如果select 结果大于0,说明有错误.
select col.... from table1 where ()
if @@error<>0
begin
set @errNum=1
goto errHandle
endselect col.... from table2 where ()
if @@error<>0
begin
set @errNum=2
goto errHandle
endselect 0
return errHandle:
select @errNum如果select 结果大于0,说明有错误.
insert into [临时表] select ..
存储过程执行后,直接查询临时表.