Answer Posted / 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
Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Explain raiserror in sql server?
what stored procedure can you use to display the current processes? : Sql server administration
What are the difference between primary keys and foreign keys?
What is the user of Primary key?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Can you type more than one query in the query editor screen at the same time?
What are extended events in sql server?
What is raid and what are different types of raid levels?
Can we insert data into a view?
What is meant by indexing?
Define left outer join in sql server joins?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What are the tables in sql?
What is use of dbcc commands?
How to insert a new row into a table with "insert into" statements in ms sql server?