Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are transactions in sql?
Explain the ways to controlling cursor behavior?
What is the purpose of the model database?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is the use of @@spid?
what is the difference between Tabular and Matrix report?
Can a rule be bound to any column of any data type?
Can we hide the definition of a stored procedure from a use?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is the difference between left and right outer join?
How can you start sql server in different modes?
How to write a query with a right outer join in ms sql server?
Explain what is dbcc?
What are the properties of the relational tables?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
