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
How to drop an existing table?
What is the chart in report?
What is attribute? : sql server analysis services, ssas
What is temporal data type?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is unique key constraint?
Define Business Edition in SQL Azure?
Explain the properties of the relational tables?
What is dynamic cursor in SQL SERVER?
Tell me what is log shipping?
What is dbcc? Give few examples.
What are the differences between union, intersect, and minus operators?
How to use values from other tables in update statements in ms sql server?
Would you store your query in a ssrs report or a database server? State the reason why?
How can we rewrite sub-queries into simple select statements or with joins?
