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 is the default sql server instance name?
What is data set in report?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is a with(nolock)?
what is an index? : Sql server database administration
What is create command?
What are the advantages of using stored procedures?
How many categories of functions based their return modes?
What is the command used to check locks in microsoft sql server?
Can sql servers link to other servers?
Can we call stored procedure in view in sql server?
What is always encrypted?
What is the difference between upgrade and migration in sql server?
How to delete duplicate records based on single column from a table?
What is t-sql script to take database offline – take database online.
