Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between inline query and stored procedure?
- 4 Answers
- 29594 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 many sql core licenses do I need?
describe transaction-safe table types in mysql : sql dba
What has stored procedures in sql?
What are the qualities of 2nf?
what is the difference between truncate and delete statement? : Transact sql
Mention what is the use of function "module procedure" in pl/sql?
What are all types of user defined functions?
How are sql commands classified?
what is the syntax used for partition in tsql? : Transact sql
What is the difference between join and natural join?
What is the sql case statement?
What is a constraint? Tell me about its various levels.
Does truncate free space?
Is it important to partition hard disk?
How can I change database name in sql?
