This blog provides MSBI stuff and Interview Questions. And especially you can get a lot of blog's URL on SSIS,SSAS,SSRS &MOSS From different dedicators on MSBI.If you have any queries/concerns,please feel free to contact me at->msbimaster4u@gmail.com
Thursday, April 29, 2010
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
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
Subscribe to:
Posts (Atom)