What is the difference between constraints and triggers?
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
Define clusters?
What is the contrast between sql and pl/sql?
What is named calculation? : sql server analysis services, ssas
explain the storage models of olap? : Sql server database administration
What is the difference between Stored Procedures and triggers?
How to download and install microsoft sql server management studio express?
What are audit control procedures?
What is the partitioning method?
What are the new features of sql server 2008 r2 reporting service?
Why we use the openxml clause?
Explain in brief about Microsoft SQL server?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is the difference between deallocate cursor and close cursor?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How to count duplicated values in a column in ms sql server?