Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36630 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
What is the openxml statement in sql server?
What is sub-query in sql server?
What are a scheduled jobs?
Explain database normalization?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What are the types of table?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
What is sql server english query?
How efficient you are in oracle and SQL server?
What is table-valued sub query?
What is the rdl file?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Is sql server implemented as a service or an application? : Sql server database administration
How many types of stored procedures are there in sql server?
What is the meaning of resultset type_scroll_insensitive?
