Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29402 Views
- Bharat, Microsoft, I also Faced
- E-Mail Answers
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 are different types of sql commands?
What are the benefits of pl/sql packages?
what are rollup and cube in t-sql? : Transact sql
What are inner and outer joins examples of both?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is over () in sql?
What is embedded sql what are its advantages?
what is a trigger? : Sql dba
What is the difference between delete, truncate and drop command?
What are the key differences between SQL and PL SQL?
Does sql profiler affect performance?
What is the maximum size of sqlite database?
How do you concatenate in sql?
How many functions are there in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
