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

Can select statements be used on views in ms sql server?

1059


What is bit data type? What's the information that can be stored inside a bit column?

910


What is sharding?

116


Is it ok to shrink transaction log?

990


How display code or Text of Stored Procedure using Sql query in Sql Server ?

1139


How can sql server instances be hidden? : sql server security

1136


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1120


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

1049


Explain trigger and its types?

1061


How to execute a sql statement using mssql_query()?

1043


What are window functions in sql server?

1001


Do you know what are acid properties of transaction?

950


How to enter binary string literals in ms sql server?

1145


How to execute function in stored procedure sql server?

1142


How to create a dml trigger using create trigger statements?

1025