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
How to find the version of sql server? : sql server database administration
What are synonyms?
What are the advantages to use stored procedures?
explain the storage models of olap? : Sql server database administration
What is faster join or union?
What is transaction server consistency?
What is db stored procedure?
What is conditional split?
what is a live lock? : Sql server database administration
What is normalization according to you and explain its different levels?
How do clustered indexes store data?
Explain the difference between cross join and full outer join?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Define msdb database?
