在存储过程中怎样判断更新数据成功？

Question

if @@error <> 0  --no error
if @@rowcount>=1   --a least 1 record is updated

Answer 1

if @@error <> 0  --no error ???
if @@rowcount>=1   --a least 1 record is updated
declare @rc int
set @rc=0
begin
update t_log_recv set result = @p_result                                        
    where @p_fsrq = str(fssj,'YYYYMMDD') and jkls = @p_jkls                   
select @rc=@@error                                                                                  
  if （@rc=0 and @@rowcount>=1）                                                          
    set @p_sql='select ''0001'' msgno,''无此短信接收记录'' msg from dual'         
  else                                                                            
    set @p_sql='select ''0000'' msgno,''更新短信接收日志成功'' msg from dual'     
                                                                           
  commit        

Answer 2

if @@error <> 0 THEN
  成功
ELSE
  有错误
END IF

Answer 3

对,用@@error判断一下就可以了