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

Explain about thread and memory management process of SQL?

540


What is sql server used for?

556


What are trace files?

535


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

521


Why we use functions in sql server?

520






How do I find information about the install locations for the various instances running on a computer?

554


What is store procedure?

645


Which sql server is best?

518


Explain what is lock escalation?

577


explain databases and sql server databases architecture? : Sql server database administration

522


Explain different forms of normalization?

532


How to apply filtering criteria at group level with the having clause in ms sql server?

560


How to achieve Paging of records in SQL SERVER?

594


What is sql or structured query language?

683


What are the new features in SQL Server 2005 when compared to SQL Server 2000?

626