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

What are the types of processing and explain each? : sql server analysis services, ssas

1150


What type of locking occurs during the snapshot generation? : sql server replication

1332


what is the system function to get current user's user id? : Sql server database administration

1001


What is local temp table?

960


How to backup SQL Server Reporting Services ?

148


List out the differences between global and local temp tables in sql server?

1061


What is extent? Types of extents?

1193


Where sql server user names and passwords are stored in sql server? : sql server database administration

1056


Explain system rowset functions?

1001


How can we solve concurrency problems?

1054


How do you open a cluster administrator?

1053


What is the difference between an index and a unique index?

1001


Can a function call a stored procedure in sql server?

960


What is a user-defined function in the sql server and what is its advantage?

1105


Can we insert data if clustered index is disabled?

941