SQL存储过程调用"事务回滚"

CREATE PROCEDURE shiwu AS

begin tran

    update TNews set ftitle = '666' where fnewsid = 1

    delete from TClass where fclassid = 4

if @@error <> 0

begin

    rollback tran

    return 0

end

else

begin

    commit transaction

    return 1

end

GO

=================================

delete语句,为有主外键关联所有删不掉...

如果去掉下划线的部分,就算出错,第一句更新也会执行.