Difference between writing SQL query and stored procedure ?
- 15 Answers
- 71776 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 the difference between a clustered index and a non-clustered index?
What are the events recorded in a transaction log?
What is data mart? : sql server analysis services, ssas
What is the ‘fillfactor’?
What are distinctive joins find as a part of sql?
Explain the working of sql privileges?
What is difference between delete and truncate commands?
How to create new table with "create table" statements?
What are the three different part of rdl file explain them?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What does the automatic recovery do?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is create statement?
What is RAID? What are the different types of RAID configurations?
What is xdr?
