Interested to Buy Any Domain ? << Click Here >> for more details...
What is a stored procedure?
- 3 Answers
- 6159 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 |
Can truncate be rolled back?
Explain datetimeoffset data type in sal server 2008?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Define right outer join in sql server joins?
How to enter binary string literals in ms sql server?
What is scrollable cursor?
What is the partitioning method?
Do you know the policy based administration feature of sql server 2008?
How do you read transaction logs
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is database replication? What are the different types of replication you can set up in sql server?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
-
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)
