Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to Debug a Stored Procedure?

Answers were Sorted based on User's Feedback



How to Debug a Stored Procedure?..

Answer / swetha

Using PRINT command in stored procedure.
use print to check if the parameter values are fine.
When the stored procedure is executed then print will show
the output of those parameters/variables.

Is This Answer Correct ?    16 Yes 4 No

How to Debug a Stored Procedure?..

Answer / ris

Steps for debugging stored procedure is given below
1.Open the object browser
2.right click the procedure that u want to debug
3.from the popup menu select debug option
4.from the displayed window ,give the values for input
parameters
5.click the button debug

Is This Answer Correct ?    12 Yes 5 No

How to Debug a Stored Procedure?..

Answer / sivakumar

Steps for debugging stored procedure is given below
1.Open the Microsoft visual Studio
2.Select Server Explorer
3.Add Server
4.Select Database Where Procedure is located
5.Select Procedure for debug
6.Right click and select Step into stored procedure
7.Pass Parameter to that procedure
8.Then Do debug.

Is This Answer Correct ?    6 Yes 4 No

How to Debug a Stored Procedure?..

Answer / gd

you can find detailed answer here on How to Debug PL/SQL
Stored Procedures in Visual Studio http://bit.ly/15O01NM

Is This Answer Correct ?    0 Yes 0 No

How to Debug a Stored Procedure?..

Answer / bhagyashri jain

By Command
Execute Procedurename parameter1 ,parameter2,......
u can use
exec Procedurename parameter1 ,parameter2,......


Is This Answer Correct ?    1 Yes 14 No

Post New Answer



More SQL Server Interview Questions

What is update_statistics command?

0 Answers  


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  


What are the different types of collation sensitivity?

0 Answers  


How to loop through returning rows?

0 Answers  


What is single-user mode?

0 Answers  






What is the purpose of optimization?

0 Answers  


Do you know what is openxml in sql server?

0 Answers  


How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,


What are the different index configurations a table can have?

0 Answers  


WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  


What is normalization of database? What are its benefits?

0 Answers  


Explain indexes disadvantages?

0 Answers  






Categories