MSBI (SSIS/SSRS/SSAS) Online Training

Sunday, April 4, 2010

Sql Server 2005 - How to Debug SP

Hi,
we have different mechanism to debug a SP.If i have INPUT and OUTPUT parameters,we can execute SP by using the below method.
============
In order to illustrate the debugger features, create the stored procedure listed below.
CREATE procedure DebugA( @IntIn int, @IntOut int OUTPUT)as
Set @IntOut = @IntIn + 10
Return
This is a simple stored procedure that takes a number and adds 10 to that number and returns the new number in an output variable. You can execute the stored procedure with the following code in Query Analyzer:
Declare @NewInt intexec DebugA 5,@NewInt OUTPUTSelect @NewInt
Given a value of 5, adding 10 will return a value of 15.
================
-- Debug SP in Sql Server 2000
http://www.15seconds.com/Issue/050106.htm
-- Debug SP in Sql Server 2005
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/435c0c43-571a-442d-9fb9-f3f495b1f2ed
-- Debug SP in Sql Server 2008
http://msdn.microsoft.com/en-us/library/ms174763.aspx