存储过程正在成功执行，但在UI上正在显示 [英] Stored Procedure is executing successfully but on UI it's showing under process

问题描述

我已经执行了来自mozilla firefox的命令，以使用SP中的while循环为不同的数据库和不同的记录更新表的记录.

现在，距离点击命令按钮已有30分钟的时间.我正在等待浏览器上的成功消息.
但是，当我检查数据库时，所有数据库和所有记录的工作已完全完成.

因此，我想问为什么在浏览器中没有返回成功消息，而不是在浏览器选项卡上处理符号.

I have executed a command from mozilla firefox to update the records of a table using while loop in SP for different databases and different records.

Now, It''s 30 minutes over now from clicking the command button. I was waiting for Success message on browser.
But when I have checked database, it has been fully completed for all databases and all records.

So, I want to ask why it was not returned success message on browser instead of processing symbol on browser tab.

推荐答案

您是否通过传递参数检查了存储过程
像:-

have you checked the store procedure by passing argument
like :-

exec storeprocedureName,arg1,arg2,arg3

如果不是，则检查它将在多少次后返回结果.我认为这是循环的.

if not then check it that in how many times it will return result. i think in loop it was stuck.

plz显示存储过程然后执行解决方案.

plz show the Stored Procedure then do the solution.

这篇关于存储过程正在成功执行，但在UI上正在显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！