某些时间存储过程不起作用

本文介绍了某些时间存储过程不起作用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用从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.