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

Difference between a query and strored procedure?

Answer Posted / khushbu wadhwani

in procedure one time compilation is done,whereas in query
compilation is done everytime.so,procedure improves
efficiency & performance

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you convert date into julian date format?

988


what is data manipulation language? : Sql dba

988


What type of database is cloud sql?

1082


Explain the savepoint statement.

1074


Can we use ddl statements in stored procedure?

1129


how can we find the number of rows in a table using mysql? : Sql dba

1069


What does data normalization mean?

941


Is sqlexception checked or unchecked?

949


what are the different type of normalization? : Sql dba

1009


Can we write dml inside a function in sql server?

929


What is cursor explain with example?

964


What is rowid in sql?

958


State some properties of relational databases?

1037


Mention what is the function that is used to transfer a pl/sql table log to a database table?

969


What is auto increment?

972