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 the types of sql server?
What happens if you add a new index to large table?
How to fetch the next row from a cursor with a "fetch" statement?
How can we get count of the number of records in a table?
What is an execution plan? How would you view the execution plan?
Can sql servers link to other servers like oracle?
Tell me about normalization in DBMS.
What is an sql server agent?
What is the difference between insensitive and scroll cursor?
Define compound operators?
How to select all columns of all rows from a table with a select statement in ms sql server?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is a scheduled job or what is a scheduled task?
What are the operating modes in which database mirroring runs?
