Answer Posted / manisha
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
Can a function call a stored procedure in sql server?
What is the purpose of optimization?
What information is maintained within the msdb database?
Explain having clause and where clause?
What are system databases into sql server (2005/2008)?
Can we insert data into a view?
plss anybody specify tha constrian management system in dbms
What are the grouping functions?
Explain the rules for designing files and file groups in sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
Explain what is lock escalation?
Explain what you mean by 3 tier architecture.
What is a non equi join?
What are the new features of sql server 2008 r2 reporting service?
What is the current pricing model of SQL Azure?