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 do you understand by check constraint in sql server?
What is use of except clause? How it differs from not in clause?
What is trigger explain with program?
What is a sql join?
How do I view views in sql server?
Explain can you implement data mining in ssrs?
tell me the disaster recovery plan
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is always encrypted?
How to delete existing rows in a table?
What do you think of this implementation? Can this be implemented better?
What does this statement do @@rowcount?
What is the latest version of microsoft sql server?
What are the filtered indexes?
How many columns can we include on clustered index ?
