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
What will be the maximum number of index per table?
What is temporal data type?
What are different types of constraints?
What is the default Port No on which SQL Server listens?
Do you know how to make remote connection in database?
What are the different types of upgrades that can be performed in sql server?
What is Transparent Data Encryption?
What is the difference between executequery () and executeupdate ()?
List few advantages of stored procedure.
How to get a list of columns using the "sys.columns" view in ms sql server?
Explain having clause and where clause?
What is importing utility?
How do you set a trace flag in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain table valued parameters in sql server? Why tvp used?