Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36188 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sairam
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 ? | 17 Yes | 8 No |
Post New Answer View All Answers
‘Order by’ is not allowed in a view how can you sort information from a view?
Explain the database you used in your final year project?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Distinguish between nested subquery and correlated subquery?
How to access the deleted record of an event?
What is log cache in sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
How to convert numeric expression data types by assignment operations?
Explain foreign key in sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
last function used in MS Access to convert sql what function will use in sql
What do you understand by intent locks?
What is the dbcc command and why is it used?
How to apply filtering criteria at group level with the having clause in ms sql server?
Describe triggers features and limitations?
