What is a stored procedure?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What are sub-queries? Give example? In which case sub-queries are not feasible?
How except clause is differs from not in clause?
How you can minimize the deadlock situation?
What command would you use to add a column to a table in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Define DML and DCL statements?
How to make remote connection in database?
How do you find the number of rows in a table?
What is a Join in SQL Server?
how to get the automatic backup of the database in the sql server
What is history table in sql server?
What is the difference between HAVING clause and the WHERE clause?