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
Explain how many normalization forms?
What is the difference between inner join and equi join?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is de-normalization in sql database administration? Give examples?
Explain linked server in sql?
What is the difference between an index and a unique index?
How can I get data from a database on another server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is an entity-relationship diagram (erd)?
What is difference between rollback immediate and with no_wait during alter database?
Explain system functions or built-in functions? What are different types of system functions?
How to use linked server?
List out the differences between the clustered index and non-clustered index in sql server?
Can you name a few encryption mechanisms in sql server?
Can sql server 2016 run on windows 7?
