Interested to Buy Any Domain ? << Click Here >> for more details...
How to Debug a Stored Procedure?
- 5 Answers
- 14228 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 |
How do I debug a stored procedure in sql server?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
Does a full backup include transaction log?
What is the difference between varchar and nvarchar types?
What action plan is preferred if sql server is not responding?
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access
How to drop an existing table?
Does group by or order by come first?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
How we can compare two database data?
Is mysql the same as sql server?
How would we use distinct statement? What is its use?
-
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)
