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 the concepts and capabilities of sql server?
Explain the different index configurations a table can have?
Why we use functions in sql server?
What is the difference between the application object and session object?
Do you know what is difference between stored procedure and user defined function?
Describe the left outer join & right outer join. : sql server database administration
Can multiple columns be used in sql group by clause in ms sql server?
How can you list all the table constraints in a database?
What are the difference between primary keys and foreign keys?
How can you manage sql azure security?
What is a user-defined function in the sql server and what is its advantage?
How do I setup a local sql server database?
what's sql server? : Sql server database administration
What are date and time data types in ms sql server?
How do you delete a data source?
