Interested to Buy Any Domain ? << Click Here >> for more details...
What are user defined stored procedures ?
- 3 Answers
- 13388 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / s.aravindhna
Microsoft SQL Server provides the stored procedure
mechanism to simplify the database development process by
grouping Transact-SQL statements into manageable blocks.
Benefits of Stored Procedures
Why should you use stored procedures? Let's take a look at
the key benefits of this technology:
Precompiled execution. SQL Server compiles each stored
procedure once and then reutilizes the execution plan. This
results in tremendous performance boosts when stored
procedures are called repeatedly.
Reduced client/server traffic. If network bandwidth is a
concern in your environment, you'll be happy to learn that
stored procedures can reduce long SQL queries to a single
line that is transmitted over the wire.
Efficient reuse of code and programming abstraction. Stored
procedures can be used by multiple users and client
programs. If you utilize them in a planned manner, you'll
find the development cycle takes less time.
Enhanced security controls. You can grant users permission
to execute a stored procedure independently of underlying
table permissions.
Stored procedures are very similar to user-defined
functions, but there are subtle differences. For more
information, read Comparing Stored Procedures and User-
Defined Functions.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to know the last executed procedure?
What are the three forms of normalization?
what are the differences between char and varchar? : Sql dba
What do you understand by exception handling in pl/sql?
What is function and procedure?
what is the difference between delete and truncate statement in sql? : Sql dba
How do I save the results of sql query in a file?
Whis is not false in primary key?
What is the difference between joins?
How do you update f as m and m as f from the below table testtable?
When should I use nosql database?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How do I view a sql database?
Why are indexes and views important to an organization?
Where is all the data on the internet stored?
