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 key, name and value columns of an attribute? : sql server analysis services, ssas
How to create a new login name in ms sql server?
Why should we go for stored procedures? Why not direct queries?
can a database be shrunk with users active? : Sql server administration
Explain system views?
What are the pre-defined functions in the sql server?
Define cross join in sql server joins?
How to delete duplicate rows in sql server?
System requirements for sql server 2005 express edition?
What are the different types of sql server replication? : sql server replication
what is the system function to get current user's user id? : Sql server database administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is triggers and stored procedures?
Explain transaction server auto commit?
How to change the name of a database user?
