Interested to Buy Any Domain ? << Click Here >> for more details...
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.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
What are the differences between union, intersect, and minus operators?
What happens if ntwdblib.dll is missing on your machine?
What are the new scripting capabilities of ssms? : sql server management studio
Determine when an index is appropriate?
Explain candidate key, alternate key, and composite key?
What is difference between foreign key and unique key?
Explain how you can configure a running aggregate in SSRS?
Give me any three differences between Truncate and Delete.
What is use of except clause? How it differs from not in clause?
How to create a stored procedure with a statement block in ms sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is outer join in sql server joins?
Name few of the dcl commands in sql?
How can we rewrite sub-queries into simple select statements or with joins?
What is the sql server agent?
