Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between a query and strored procedure?
- 4 Answers
- 10260 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 |
What is clustered, non-clustured and unique index. How many indexes can be created on a table ?
How do you truncate?
What are the different ddl commands in sql?
What are the types of views in sql?
What does count (*) mean?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
What is sql profiling in oracle?
What is a variable in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What are sql functions? Describe the different types of sql functions?
What is dense_rank in sql?
How do I create a memory optimized filegroup?
-
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)
