Difference between inline query and stored procedure?
- 4 Answers
- 28273 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
How do I install microsoft sql?
Is sqlite good enough for production?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Define join and name different types of joins?
Explain clause in sql?
How do rank () and dense_rank () differ?
How to install oracle sql developer?
what is bcp? When is it used?
What is indexing in sql and its types?
What are all the common sql functions?
Can we use update in sql function?
what is the use of set statement in tsql? : Transact sql
What is pl sql in oracle?
What is a unique key?
What types of commands can be executed in sql*plus?
