Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36263 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
Write a code to select distinct records without using the DISTINCT keyword.
What are the recovery models in sql server 2000?
please differentiate between delete and truncate?
What is compression - row-level and page-level compression?
What are the requirements to use odbc connections in php scripts?
How to configure odbc dsn with different port numbers?
How to connect a database with sql express.?
how to invoke a trigger on demand? : Sql server database administration
Explain multiserver query
Explain system views?
What is difference between foreign key and unique key?
How data can be copied from one table to another table?
What action plan is preferred if sql server is not responding?
How many types of the database links?
What are the different Topologies in which Replication can be configured?
