What are the differences between triggers and stored procedures?
- 1 Answers
- 1156 Views
- I also Faced
- E-Mail Answers
Answer Posted / Santosh Saraswat
Stored Procedures are precompiled collections of SQL statements and are called explicitly, while Triggers are automatically executed in response to certain events on a specific database object.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you index views?
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 one drop a column from a table?
What is a coalesce function?
What is clustered index
What is temporary table in sql server? Why we use temp table?
What is self contained sub query?
What are the source of constraints?
What are different types of constraints?
What is normalization and what are the advantages of it?
Disadvantages of the indexes?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How raid can influence database performance?
What is the difference between upgrade and migration in sql server?
What is an indexed view?
