Difference between inline query and stored procedure?
Answer Posted / sharad prakash singhania
Procedure resides in the database in the executable format
whereas in case of inline query, SQL always take a step to
compile the query and then execute it. So In this respect
Procedure takes less time to execute whereas query take more
time to execute.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What is rank dense_rank and partition in sql?
Is primary key clustered index?
Is microsoft sql free?
Does db2 use sql?
What is the difference between left and left outer join?
What is the difference between having clause and where clause?
What is java sql connection?
How do I view a sql trace file?
How to order siblings in oracle hierarchy queries?
How to select unique records from a table?
What are secondary keys?
What is lookup table in sql?
How does sql profiler work?
What is sql dialect?
what is a relationship and what are they? : Sql dba