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.

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

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.

Answer / gd

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

Answer / bhagyashri jain

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

What is difference between inner join and full join?

0 Answers  

How to create a local temporary stored procedure?

0 Answers  

What is the difference between migration and upgradation in sql server?

0 Answers  

What are different types of database indexes?

0 Answers  

How do you delete duplicate records in sql server?

0 Answers  

What is difference statement and preparedstatement?

0 Answers  

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

What is a transaction and why is it important?

0 Answers  

How to modify an existing stored procedure in ms sql server?

0 Answers  

How to use subqueries with the in operators in ms sql server?

0 Answers  

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,