当我调用存储过程时，我与存储过程的连接必须返回并且SP应该在后端运行 [英] when i Call store Procedure my connection from store procedure has to return and SP should run in back end

问题描述

在数据访问层中使用asp.net我叫execurenonquery我的存储过程花了10分钟，所以，我想在执行SP之前为其他操作找回光标，因为我将在执行SP后更新状态标志，因此每当我要成功检查我的WheatSP时，我都会检查DB中的标志.

即使出现连接超时问题.

谢谢
karthik

using asp.net in data acesses layer i called execurenonquery my store procedure takes 10 min so , i want to get my cursor back before execution of my SP for another operation , because i will update a Status flag after my SP execution so when ever i want to check my wheather SP excuted succesfully i will check flag in DB .

even if giving problem Connection time out.

thanks
karthik

推荐答案

使您的问题更清楚，这是无法理解的...

make your problem more clear , its not understandable ...

尝试更新sp中的标志状态.
10分钟对于数据库执行过程来说太长了.您应该减少执行时间.

try to update your flag status inside sp.
and 10 min is too long for a db execution process. u should takedown the execution time.

这篇关于当我调用存储过程时，我与存储过程的连接必须返回并且SP应该在后端运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！