How to Debug a Stored Procedure?
- 5 Answers
- 12689 Views
- Allianz, I also Faced
- E-Mail Answers
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 |
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
What are the different types of sub-queries?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How can we delete Duplicate row in table?
Why olap is used?
What is lock escalation?
What is the purpose of using COLLATE in a query?
Explain “row_number()” in sql server with an example?
how many bits ip address consist of? : Sql server database administration
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How to find the version of sql server? : sql server database administration
How to include text values in sql statements?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
