Answer Posted / 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.

Explain important index characteristics?

1025

---

What is an execution plan?

1136

---

Can you explain important index characteristics?

985

---

What are the tables in sql?

1081

---

What is an identity column in insert statements?

1014

---

How to get the number of affected rows?

996

---

What are the Advantages of using CTE in sql server?

1107

---

What is sql injection and why is it a problem? : sql server security

1123

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2739

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4372

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

974

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1032

---

What is page in sql server?

941

---

What is indexed view? How to create it?

981

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

984

---