Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 transaction server distributed transaction?

1039


What are triggers? How do you invoke a trigger on demand?

1365


How can you stop stored procedures from recompiling?

948


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

940


How do I manually uninstall an instance of sql server 2016?

1080


What are the parts of a function?

990


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1073


What happens if you are trying to access a schema not owned by you?

1020


When columns are added to existing tables, what do they initially contain?

1097


Can we call future method from trigger?

1005


what do you understand by change data capture?

1078


What is clustered index

1060


How to create a stored procedure with a statement block in ms sql server?

1129


What is explicit cursors?

1123


What is difference between foreign key and unique key?

1049