Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29431 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
Are views faster than queries?
What is the default isolation level in sql server? : Transact sql
Write a unique difference between a function and a stored procedure.
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is a common use of group by in sql?
What is a composite primary key?
Explain what is a view?
How do rank () and dense_rank () differ?
What are database links used for?
What is an example of translating a date into julian format?
What are dml commands?
What is difference between primary and secondary key?
What is bulk compiling in pl/sql.?
what are aggregate and scalar functions? : Sql dba
what is the difference between blob and text? : Sql dba
