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
Explain what is use of dbcc commands?
When you should use a low fill factor?
How to convert a table data in XML format in sql server?
Explain the properties of subqueries in sql server?
What is a primary index?
What are window functions in sql server?
What purpose does the model database server?
How can you hide the sql server instances?
What is ms sql server index?
What is the difference between count and distinct count?
How many columns can we include on clustered index ?
What is the maximum size of a row in sql server?
How to retrieve error messages using mssql_get_last_message()?
Tell me when is the update_statistics command used?
What is the ‘fillfactor’?
