如何显示每个块存储过程执行状态的状态? [英] How to show a status of each block Stored Procedure Execution Status?

问题描述

亲爱的所有人，

面试中有人问我一个问题.问题是，

存储过程包含3个执行块.第一个块包含对几个缺少记录的插入语句，第二个块包含用于更新几千条记录的更新语句，第三块包含用于删除几千条记录的delete语句. < b>如何在ASP.NET应用程序中显示每个块执行状态的状态</b> ;.

我已经回答了，我们可以使用状态栏控件来显示状态.但这似乎是不正确的.还有其他方法可以显示每个块的状态吗?

谢谢

问候，
P.Mohan Giri

Dear All,

I had been asked a question in interview. The question is,

A stored procedure contains 3 blocks of execution. First block contains insert statement to few lack records and second block contains update statement to update few thousand records and third statement contains delete statement to delete few thousand records. <b>How to show the status of each block execution status in ASP.NET application</b>.

I have answered, we could use status bar control to show the status. But seems it''s not correct. Is there any other way to show the status of each block?

Thank you,

Regards,
P.Mohan Giri

推荐答案

以下链接已回答问题

http://www.bigresource.com/MS_SQL-SQLInfoMessageEventHandler-和-PRINT-statement-in-SQL-Express-tVGKsLuU.html [

Following Link has answer to the question

http://www.bigresource.com/MS_SQL-SQLInfoMessageEventHandler-and-PRINT-statement-in-SQL-Express-tVGKsLuU.html[^]

这篇关于如何显示每个块存储过程执行状态的状态?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！