Difference between a query and strored procedure?
- 4 Answers
- 8774 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is sql a scripting language?
What is the difference between explicit and implicit cursors in oracle?
what is commit? : Sql dba
what is the difference between group by and order by in sql? : Sql dba
what is the difference between char_length and length? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
What is dense_rank?
How many postgresql users are there, worldwide?
Are left and right joins the same?
What is compilation error in pl sql?
how to create a new table in mysql? : Sql dba
Is truncate ddl or dml?
How can you get sql*loader to commit only at the end of the load file? : aql loader
what are date and time functions in mysql? : Sql dba
What is sql data?
