Question

I have a very complex T-SQL procedure about 2000 lines (I didn t develop it). I was asked to fix some bugs on it. I tried some methods as:

My question:
What s the best method to debug a procedure like this?

Answer 1

首先,将程序重新纳入可单独测试和破碎的多个较小程序。

Answer 2

除印刷说明外,您还可使用http://msdn.microsoft.com/en-us/library/ms177564.aspx” rel=“nofollow”题目=“OUTPUT Clause (Transact-SQL)”output 。您的大多数询问(包括插入、更新和复制;删除)中的条款,以便你能够看到中间结果,同时又不破坏程序的流动。例:

删除声明:

delete [tbl]
output deleted.*
 where [something] =  stuff ;

加入:

insert [tbl]
output inserted.*
values (42,  things );

最新发言:

update [tb]
output deleted.*, -- Original values
       inserted.* -- Updated values
   set [something] =  poopen 
 where [id] = 42;

Answer 3

利用SQ简介仪

附录三

只有在非PROD环境中才能使用和测试这些技术。