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

Write the syntax for stuff function in an sql server?

1070


Do you know what is openxml in sql server?

1113


What are partitioned views?

1048


What do you mean by acid?

1048


Where are SQL server users names and passwords are stored in sql server?

1322


Explain raiserror in sql server?

1075


How to execute function in stored procedure sql server?

1227


Write a sql query to delete duplicate records from a table called table1

1085


What is a fan-out query in SQL Azure?

123


Difference between connected and disconnected database in .net with sql server?

1145


How to provide default values to stored procedure parameters?

1099


What is sqlservr.exe - process - sql server (sqlex?press)?

1151


What are the lambda triggers?

956


How do you send email on SQL Server?

1113


How to create prepared statements using odbc_prepare()?

1099