Query and Procedures

[prachee_singh]

Can any one explain me exactly what is the difference between query & procedure? when we get the same result of any question by proceeding query then why we are suggest to use procedure? and where we can give up query for procedure? explain with proper example plz

[debasisdas]

A procedure is a pre-compile dblock of code. So it is not recompiled at runtime .But a SQL query is parsed everytime before execution . SO performance wise PROCEDURE is faster than a query.

[susarlasireesha]

Can any one explain me exactly what is the difference between query & procedure? when we get the same result of any question by proceeding query then why we are suggest to use procedure? and where we can give up query for procedure? explain with proper example plz

sql query is need to be complied every time when it is executed.where as
procedures are compiled only once when they are executed for the first time.
procedure is faster than query