Answer Posted / m.k.manikandan
There are several purposes of using stored procedures
instead of standard SQL. First, stored procedures allow a
lot more flexibility offering capabilities such as
conditional logic. Second, because stored procedures are
stored within the DBMS, bandwidth and execution time are
reduced. This is because a single stored procedure can
execute a complex set of SQL statements. Third, SQL Server
pre-compiles stored procedures such that they execute
optimally. Fourth, client developers are abstracted from
complex designs. They would simply need to know the stored
procedure's name and the type of data it returns.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do you create type- insensitive operator?
How do I find my localdb version?
Explain the benefits of user-defined functions?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How to use union to merge outputs from two queries together in ms sql server?
How do I find query history in sql server?
Do you know what are the properties of the relational tables?
What is a trigger and types of a trigger?
How to find the second highest salary of an employee?
What are the kinds of subquery?
How to create an multi-statement table-valued function?
What is the recursive stored procedure in sql server?
How do I schedule a sql server profiler trace?
In which format does an image save in SQL Server database ?
How to replace given values with null using nullif()?
