进度条显示完成sql执行查询的百分比，标签应显示正在执行哪个员工. [英] progress bar showing the percentage of completing sql executing query, and the label should show which employee executing is in process.

问题描述

进度条，显示完成sql执行查询的百分比，

progress bar showing the percentage of completing sql executing query,
and the label should show which employee executing is in process.

推荐答案

如果没有很多工作，这是不可能的.如果您在运行简单查询时能收到这样的反馈，那就太好了.当然，不想一次处理一个记录，除非您愿意这样做，这并不实际.您可以编写代码来获取记录计数，然后使用具有skip and take参数的存储过程一次读取1％的代码.这将减慢该过程的速度.

Without a lot of work, this is not possible. It would be real nice if you could get feedback like this when running a simple query. Of course do not want to process one record at a time, unless you are willing to do this, not really practical. You could write code that would get the count of records, and then read 1% at a time using a stored proceedure that has a skip and take argument. This will slow down the process.

在第一部分中进行了介绍..我没有得到第二部分的问题..
http://stackoverflow.com/questions/9470634/how-to-indicate-the-current-progress-of-querying-a-large-dataset [

have a look at this for first part..I didn''t get the second part of question..
http://stackoverflow.com/questions/9470634/how-to-indicate-the-current-progress-of-querying-a-large-dataset[^]

这篇关于进度条显示完成sql执行查询的百分比，标签应显示正在执行哪个员工.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！