Difference between inline query and stored procedure?
- 4 Answers
- 27608 Views
- Bharat, Microsoft, I also Faced
- E-Mail Answers
Answer Posted / inam abbas
1) stored procedure comes with some major characterstics, as it consists in pre compiled format so the performance increase during dataaccess. incase of simple query it requires to complie again and again as per user request, but here its not required due to precompile format (*compile requires only ones).
2)next it reduce the network traffice so impacts less burden on server and u can integrate it with different front-end applications (e.g. vb.bnet,c#,java etc) inorder to data access.
3)come to next, due to precompile code resides in database server it provides more security and due to complicated queries can be integrated with one form it is portable also.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the reports view in oracle sql developer?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How to get list of all tables from a database?
What is bulk collect in pl sql?
What are the parts of a sql statement?
Is hadoop a nosql?
What is a scalar value in sql?
what is data integrity? : Sql dba
what are wild cards used in database for pattern matching ? : Sql dba
What are the different types of functions in sql?
What is mutating error?
Is sql database free?
What is sorting in sql?
What is the use of <> sql?
What is pivot in sql?
