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 / tathagoto

query will be compiled each time excution
stored procedure will be compiled once and after that it
will execute when it will be called....

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the basic structure of an sql?

1099


Can I learn sql in a week?

1076


What is function and procedure?

1033


What is a pragma statement?

1263


what is msql? : Sql dba

989


What is a temporal table?

931


what is bdb (berkeleydb)? : Sql dba

1035


Explain normalization and what are the advantages of it?

953


What has stored procedures in sql?

1067


What is cartesian join in sql?

1132


What is a data definition language?

1133


Explain foreign key in sql?

1026


Are sql database names case sensitive?

1006


What is assignment operator in pl sql?

1038


What is foreign key and example?

938