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,......

How to copy data from one table to another table?

0 Answers  

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

What does it mean to normalize data?

0 Answers  

---

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 Answers  

---

Explain multiserver query

0 Answers  

---

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

What is built-in/administrator?

0 Answers  

---

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

---

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

---