What is the difference between constraints and triggers?
- 9 Answers
- 34848 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sairam singh
Both will be used to implement business rules.
Constraints will do memory location to table comparision.
where as triggers will do table to table comparision.
for this triggers will use magic tables(inserted,deleted).
In the order of precedence first Constraints next Triggers,
But performance wise triggers will give best performance
because table to table comparision is faster than memeory
location to table comparision.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
what authentication modes does sql server support? : Sql server database administration
What are three major types of constraints?
What is the difference between having clause and where clause in sql server?
What are the components of sql server service broker?
What are different types of database indexes?
what are the types of indexes? : Sql server database administration
Is it true, that there is no difference between a rule and a check constraint?
How can you check the version of sql server?
Define indexes?
What is normalization of database?
Can you insert NULL in unique column?
What is report rendering ?
Explain sql delete command?
What are the underflow and overflow behaviors on float literals?
What will be the maximum number of index per table?
