Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Query and Procedures

This is a discussion on Query and Procedures within the Database General forums, part of the Databases category; 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 ...

Geeks Talk > Databases > Database General Query and Procedures

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-09-2008

prachee_singh Junior Member   Join Date: Sep 2006 Location: patna Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Query and Procedures 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

Sponsored Links

#2 (permalink)   02-18-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: Query and Procedures 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.

#3 (permalink)   02-19-2008

susarlasireesha Expert Member   Join Date: Apr 2007 Location: Bangalore Posts: 447 Thanks: 20 Thanked 54 Times in 54 Posts

Re: Query and Procedures Quote: Originally Posted by 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 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

Geeks Talk > Databases > Database General

« Faster approach for querying | Replication »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can we use procedures within Views	Subashini.Ramasamy	SQL	7	02-12-2008 10:08 AM
Oracle functions and procedures	vellas	Oracle	10	09-13-2007 12:22 PM
User defined procedures	Data911	MainFrame	0	08-31-2007 01:48 PM
Test cases for testing databases & stored procedures	rafina	Test Cases	2	08-16-2007 12:37 PM
execute MS-SQL Stored procedures from QTP	Geek_Guest	QTP	0	06-09-2007 01:53 PM

All times are GMT -4. The time now is 07:42 PM.