Interested to Buy Any Domain ? << Click Here >> for more details...
What is a stored procedure?
- 3 Answers
- 6436 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 |
What is dml command?
How to create function with parameter in sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How will you decide the active and passive nodes?
what is the Enterprise manager(2000) and management studio (2005)?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
What is the difference between having and where clause?
How to find the list of fixed hard drive and free space on server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What are date and time data types in ms sql server?
i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj
Can you explain the role of each service?
-
Oracle (3253) - 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)
