How to Debug a Stored Procedure?

Answer Posted / bhagyashri jain

By Command
Execute Procedurename parameter1 ,parameter2,......
u can use
exec Procedurename parameter1 ,parameter2,......


Is This Answer Correct ?    1 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add the custom code in Report?

96


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

558


Why do we use non clustered index?

545


How can I create a new template for import ? : sql server management studio

587


Is sql server implemented as a service or an application? : Sql server database administration

505






How do you know if sql server is running on your local system?

529


Can we take the full database backup in log shipping?

529


Which tcp/ip port does sql server run on? How can it be changed?

564


What does it mean to manipulate data?

548


Is it true, that there is no difference between a rule and a check constraint?

515


What is the library index called?

578


How dts is used to extract, transform and consolidate data?

584


Explain error handling in ssis?

559


Explain in brief how sql server enhances scalability of the database system?

470


what is a deadlock? : Sql server database administration

485