How to Debug a Stored Procedure?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / bhagyashri jain
By Command
Execute Procedurename parameter1 ,parameter2,......
u can use
exec Procedurename parameter1 ,parameter2,......
Is This Answer Correct ? | 1 Yes | 14 No |
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
Explain indexed views?
What is global temp table?
What does the automatic recovery do?
Explain Geometry datatype in sql server 2008 with example
where can you add custom error messages to sql server? : Sql server administration
How to select Distinct columns from the table, table having 20 columns and i want all coulmns
can you any body tell me the difference between candidate key and primary key
What are the different subsets of sql?
syntax and example for bitmap index in sql???
What does it mean to invest in the index?
Explain left outer join and right outer join?