What is a stored procedure?

Question Posted / guest

3 Answers
6316 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a stored procedure?..

Answer / vijay

Stored procedures are precompiled database queries that
improve the security, efficiency and usability of database
client/server applications. Developers specify a stored
procedure in terms of input and output variables. They then
compile the code on the database platform and make it
available to aplication developers for use in other
environments, such as web applications. All of the major
database platforms, including Oracle, SQL Server and MySQL
support stored procedures. The major benefits of this
technology are the substantial performance gains from
precompiled execution, the reduction of client/server
traffic, development efficiency gains from code reuse and
abstraction and the security controls inherent in granting
users permissions on specific stored procedures instead of
the underlying database tables.

Is This Answer Correct ?

3 Yes

0 No

What is a stored procedure?..

Answer / hokar

stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.

Is This Answer Correct ?

2 Yes

1 No

What is a stored procedure?..

Answer / casmir

stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer