Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29242 Views
- Bharat, Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sudama maharana
1. Stored procedure is loaded to database once it compiled, but inline queries are not loaded in to server. So, Stored procedure is in compiled form.
2. As Stored procedure is in compiled form, so in each calling to it, it takes less time than inline queries. Because in Stored procedure we are passing only the names, but in inline query we are passing the whole query.
3. Stored procedures are compiled only once and in each calling its only executing the query. But inline queries are compiled & executed in each calling. So, in stored procedure network Traffic is less.
4. In stored procedure, we can pass parameters . But in inline query we can't pass.
Thanks
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I remove all records from a table?
What are the popular database management systems in the it industry?
how to delete an existing column in a table? : Sql dba
How do I make sql search faster?
What is not equal in sql?
How do I order columns in sql?
What are procedures used for?
What is the cause of mutating table error and how can we solve it?
What is sap sql?
What is the difference between a procedure and a function?
What is set serveroutput on?
How do I create a sql script?
what is the difference between char and varchar data types? : Sql dba
How to display the records between two range in Oracle SQL Plus?
What is the difference between a query and a report?
