Difference between a query and strored procedure?

Question Posted / geethu

Answers were Sorted based on User's Feedback

Difference between a query and strored procedure?..

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

Difference between a query and strored procedure?..

Answer / srao

Query is nothing but a single statement to retrieve data
from one or more tables.

Procedure is nothing but the combinations of Different
queries.

Is This Answer Correct ?

8 Yes

4 No

Difference between a query and strored procedure?..

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

Difference between a query and strored procedure?..

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