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 perform key word search in tables?

729


Should you normalize audio?

713


How do I setup a sql server database?

766


What is the command dbcc checkdb used for?

713


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

714






what is package and it uses and how can u call a package

1775


What is mean by candidate key?

750


Differentiate between ms sql server reporting services vs crystal reports?

661


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

748


Explain different types of collation sensitivity?

703


What are the new features of sql server 2012 reporting service?

101


What is update_statistics command?

765


Does a sql server 2005 select statement require a from?

780


What happens if we shrink log file in sql server?

696


How can you ensure that the database and sql server based application perform well?

796