Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76981 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / raghuraja, sivaganga, india
Advantage in Programming - If you are using Query in your
program exe, want to change Query, you have to change query
and compile it again. But if used Stored procedure, no need
to recompile just modify the sp. Query is slow and SP is
fast.
| Is This Answer Correct ? | 30 Yes | 10 No |
Post New Answer View All Answers
What is sql server schema compare? How we can compare two database schemas?
What does it mean to be in union?
What the different types of Replication and why are they used?
What are the 7 disadvantages to a manual system?
What is the purpose of the master database?
What are the different SQL Server Versions you have worked on?
How do I find my localdb version?
How are the unique and primary key constraints different?
What is the difference between join and inner join?
how would you improve etl (extract, transform, load) throughput?
How to defragment indexes with alter index ... Reorganize?
What is report subscription?
What do you mean by subquery?
Can we use pragma autonomous_transaction in trigger?
What is acid db?
