某些时间存储过程不起作用 [英] Some Time Stored Procedure Not working

问题描述

我正在使用从db.now中读取值的过程.在这种情况下，控制台应用程序中的执行速度非常高.在某些情况下，过程不会返回任何值.

i am using procedure for reading values from db.now iam woring in console application its execution speed very high in this situation some time procedure not returning any value.

推荐答案

对SQL数据库的常规调用将阻止调用-它们不会返回，直到从数据库返回结果为止-对数据库的调用超时，未正确调用它们或存储过程有错误.

无论如何，在帮助您之前，我们需要先查看相关的代码fragamnets.

Since normal calls into SQL databases are blocking calls - they do not return until the result is returned from the DB - either your calls to the database are timing out, you have not called them correctly, or your stored procedures are faulty.

In any case, we would need to see the relevant code fragamnets before we could help you.

这篇关于某些时间存储过程不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！