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...

What is a Stored Procedure?

Answer Posted / babu

stored procedure is PL SQL statement that is called by a name
procedure perform a task, they does not return value.
1.reduce network traffic
2.reduce server overhead
3. Excution plan may be reused
4.provide good security for our data

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain boyce and codd normal form(bcnf)?

920


Explain syntax for dropping triggers?

915


What is a constant or literal in ms sql server?

1024


How can you check the level of fragmentation on a table?

1030


What new data source types were added in ssrs 2014?

160


What is ssl in sql server?

1055


What is subquery? Explain the properties of a subquery?

960


Does sql server 2000 full-text search support clustering?

845


How many columns can we include on clustered index ?

967


Where actually sql azure database is hosted?

163


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

930


What is difference between count (*) and count 1?

909


How do you make a trace?

998


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

984


what is datawarehouse?

1095