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 / r.s.chauhan

Sp gets stored at the server side where as Not necessary
for query(It can be from application or Clint(sql oem) etc)

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

who introduced sql?

1023


Can you select everything, but 1 or 2 fields, without writer's cramp?

984


Which is better join or subquery?

1137


What is linq to sql?

1133


Name some usages of database trigger?

1021


How does a self join work?

1128


What is full form of rtm?

1008


How can I speed up sql query?

963


What is sql and db2?

1008


What is form and report?

990


Why do we need sharding?

991


What operating systems are supported by oracle sql developer?

966


How many sql databases can you have on one server?

1084


What is union and union all keyword in sql?

1043


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4017