Interested to Buy Any Domain ? << Click Here >> for more details...
How to Debug a Stored Procedure?
- 5 Answers
- 14247 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 purpose of object explorer and its features? : sql server management studio
How you can add messages to the nt event log from within a stored procedure?
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
How do I find the transaction log size in sql server?
How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005
How to delete a database in ms sql server?
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
How retrieve field names from the table in SQL through JAVA code?
Can you explain various data region available in ssrs with their use?
Explain go command in sql server?
what is a schema in sql server 2005? : Sql server database administration
Is truncate a dml command?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
