Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between a query and strored procedure?
- 4 Answers
- 10219 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to run sql functions in pl/sql?
Can we debug stored procedure?
What are different types of indexes?
What is normalization? How many normalization forms are there?
what tools available for managing mysql server? : Sql dba
Does pl/sql support create command?
What is data definition language?
Enlist some predefined exceptions?
Explain the select statement in sql?
What is the example of procedure?
What is pl sql script?
What is rowid in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
