Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29207 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 to select random rows from a table?
What is a column in a table?
What is composite primary key in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
How to check if a column is nullable before setting to nullable?
Can we perform dml on view?
Is left join same as inner join?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What are the disadvantages of not performing database normalization?
What are the main features of cursor?
What is the trigger in sql?
How many types of literals are available in pl sql?
what is the difference between char_length and length? : Sql dba
What is sql engine in oracle?
What is sap sql?
