Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between writing SQL query and stored procedure ?
- 15 Answers
- 76202 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 is the temp table?
Explain the difference between function and stored procedure?
What stored procedure can you use to display the current processes?
In how many ways you can invoke ssrs reports?
Explain time data type in sal server 2008?
Explain try...catch with sql server?
What are partitioned views?
What are different types of statements that are supported by sql?
How to find the service pack installed? : sql server database administration
Describe in brief databases and sql server databases architecture.
How efficient you are in oracle and SQL server?
Explain trigger and trigger types?
What is an execution plan?
What is cursor in ms sql server?
What is difference between group by and having?
