执行带有事务管理的存储过程，是否能返回实际执行的条数？
答案:2 悬赏:10 手机版
解决时间 2021-02-08 14:12
- 提问者网友：雪舞兮
- 2021-02-08 06:20
执行带有事务管理的存储过程，是否能返回实际执行的条数？
最佳答案
- 五星知识达人网友：酒醒三更
- 2021-02-08 06:32
BEGIN
start transaction;
decalre @insert_count int,
decalre @update_count int,
set @insert_count = (insert tb_answers(a_question_id,a_user_id,a_context,a_picture,a_answer_time,a_best) values (question_id,user_id,context,picture,answer_time,best));
set @update_count = (update tb_questions set q_answers_amount=q_answers_amount+1 where q_id=question_id);
if @@error_count = 0 then
commit;
else
rollback;
end if;
select @insert_count as InserCount
select @update_count as UpdateCount
END
start transaction;
decalre @insert_count int,
decalre @update_count int,
set @insert_count = (insert tb_answers(a_question_id,a_user_id,a_context,a_picture,a_answer_time,a_best) values (question_id,user_id,context,picture,answer_time,best));
set @update_count = (update tb_questions set q_answers_amount=q_answers_amount+1 where q_id=question_id);
if @@error_count = 0 then
commit;
else
rollback;
end if;
select @insert_count as InserCount
select @update_count as UpdateCount
END
全部回答
- 1楼网友：第幾種人
- 2021-02-08 08:06
可以 在该跳出的地方 RETURN @@ROWCOUNT;
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯