Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the stuff and how does it differ from the replace function?
Can binary strings be converted into numeric or float data types?
What is a database in ms sql server?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are commonly used mssql functions in php?
What is the security principal at the server level that represents your session?
What guidelines should be followed to help minimize deadlocks?
What happens to a trigger with multiple affected rows?
How to modify an existing user defined function?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain the flow of creating a cube? : sql server analysis services, ssas
How to use subqueries with the exists operators in ms sql server?
Explain differentiate between a having clause and a where clause?
What command must you use to include the not null constraint after a table has already been created?
What are different types of subquery?
