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 clustered primary key?

0 Answers  

How to write character string constants or literals in ms sql server?

0 Answers  

What is store procedure? How do they work? When do you use?

0 Answers  

When should you use an instead of trigger?

0 Answers  

How do I open port 1433?

0 Answers  

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

What happens if null values are involved in comparison operations?

0 Answers  

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

What is logon trigger?

0 Answers  

Explain what are commit and rollback in sql?

0 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

What is oltp (online transaction processing)?

0 Answers