How to Debug a Stored Procedure?

Answer Posted / swetha

Using PRINT command in stored procedure.
use print to check if the parameter values are fine.
When the stored procedure is executed then print will show
the output of those parameters/variables.

Is This Answer Correct ?    16 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the properties of a relational table?

545


What is user defined datatypes and when you should go for them?

563


What is relationship? What number of sorts of relationship are there?

621


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

557


What is constraints and its types?

482






Explain partitioned view?

575


What are page splits?

573


How to find index size for each index on table?

573


What is linked report?

87


What is the default value of an integer data type in sql server 2005?

570


What are views in ms sql server?

587


Explain about SQL server 2005?

549


What is msdb database? : SQL Server Architecture

520


What is update_statistics command?

560


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1601