Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29371 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
How does rowid help in running a query faster?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How do you write a subquery?
Does truncate remove indexes?
What version is sql?
What is trigger point?
What do you mean by table in sql?
Mention what does plv msg allows you to do?
What is a database? Explain
What are stored procedures used for?
How can we avoid duplicating records in a query?
How to run sql statements through the web interface?
What is sql in java?
How many types of indexes are there in sql?
What do you know by pl/sql cursors?
