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 is field with example?
what command is used to create a table by copying the structure of another table?
Explain time data type in sal server 2008?
How can we use ConnectorJ JDBC Driver with MS SQL?
Explain log shipping?
What is default port number for sql server 2000?
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
How to get the number of affected rows?
What is a dbms wizard?
How to use order by with union operators in ms sql server?
Where is trigger in sql server?
What Is The Difference Between Primary Key & Super Key
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)