Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76954 Views
- Cognizant, Infosys, TCS, Veritas, I also Faced
- E-Mail Answers
Answer Posted / vial
stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses
| Is This Answer Correct ? | 77 Yes | 21 No |
Post New Answer View All Answers
What happens to a statement batch if there is a compilation error?
How you can change a cross join into an inner join?
What are the properties of sub-query?
Why do we use functions?
Explain the truncate command? : SQL Server Architecture
What is the default fill factor value?
Explain features of analysis services?
What is the difference between NOROW and LOCKROW?
How many replicas are maintained for each sql azure db?
What is isnull() operator?
What are types of storage modes? : sql server analysis services, ssas
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What do we need queues in sql service broker?
What is explicit mode in sql server?
What do you understand by recursive stored procedures?
