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 different types of database indexes?
How will you find out if there are expensive SQL statements running or not?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to drop existing views from a database in ms sql server?
What are the restrictions while creating batches in sql server?
How to use subqueries with the exists operators in ms sql server?
What are sql server functions?
Explain the collation?
What are the drawbacks of reporting in ssrs?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is encryption key?
Write a sql query to delete duplicate records from a table called table1
Where are full-text indexes stored?
What is difference statement and preparedstatement?
What is the difference between clustered index and primary key?
