What are the advantages of using a stored procedure?
- 1 Answers
- 1103 Views
- I also Faced
- E-Mail Answers
Answer Posted / Aarti Martolia
"Stored procedures offer several benefits, including improved application performance due to reduced network traffic and faster execution time, increased security as they can be secured at the server level, easier code maintenance by encapsulating complex logic, improved error handling with customized error messages, and reusability of SQL code across multiple applications."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is clustered index
What are the kinds of subquery?
Can one drop a column from a table?
How can you append an identity column to a temporary table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can sql servers link to other servers like oracle?
Can you index views?
Disadvantages of the indexes?
What is a view in sql?
How to remove duplicate rows from table except one?
How can I check that whether automatic statistic update is enabled or not?
What is the difference between upgrade and migration in sql server?
Can we do dml on views?
