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
Does sql server use java?
What is ssrs?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How do I find sql server instance name?
how to use DTS package in 2000,2005,2008 in sql server
what is sql server? : Sql server database administration
What is subquery explain with example?
How to enter unicode character string literals in ms sql server?
What is the synonym of join?
What stored by the msdb?
what are constraints? Explain different types of constraints? : Sql server database administration
Explain system views?
What are the reporting services components?
what are the new features in SSRS?
on line cluster can we make if yes tell me the procedure
