阅读背景:

Sql Server在while循环期间打印受影响的行

来源:互联网 

I have a stored procedure running on sql server 2008 looping over a table of ~50 million rows, deleting records one day at a time (approx. 25,000 records a day). I want to be able to watch this occur as the process runs via print statements to the messages window. I'd like to be able to see a message each time a day's worth of deletions is committed. Is there any way to do something like this? The procedure is roughly laid out like this:I have a stored procedure running on sql server




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: