Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36607 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
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is normalization process?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What causes index fragmentation?
How do we know if any query is retrieving a large amount of data or very little data?
How is a full-text index updated?
Why main is user defined function?
Explain raiserror in sql server?
What is inner join in sql server joins?
Do I need a report server to run reports in my application?
What is best institute to Learn DotNET And SQL in chennai?
how you can get the list of largest tables in a database? : Sql server administration
What are the types of dml?
What is the New in SQL server 2008?
