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
Define outer join?
What are different backups available in sql server?
What does it mean to manipulate data?
How to insert multiple rows with one insert statement in ms sql server?
Can we insert data into a view?
Explain differences between web edition and business edition?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What are parameterized reports? What are cascading parameters in ssrs reports?
How to connect to a sql server using odbc_connect()?
Explain tablesample?
How to filter records of table in SQL SERVER?
How to use go command in "sqlcmd"?
How column data types are determined in a view?
How can I create a report based on a query? : sql server management studio
What is #temp and @table variable in SQL server?
