Interested to Buy Any Domain ? << Click Here >> for more details...
What is a stored procedure?
- 3 Answers
- 6112 Views
- I also Faced
- E-Mail Answers
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 |
Explain syntax for viewing trigger?
What stored by the msdb? : sql server database administration
Can group by be used without aggregate functions?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
What is an identity column in insert statements?
How to turn off warning messages during php execution?
Which is better statement or preparedstatement?
can you any body tell me why are go for the rebuild the master database.what is the reason?
Explain the use of containers in ssis and also their types?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
find 2nd highest salary of person using cursor concept?
-
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)
