What is the difference between constraints and triggers?
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
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is a partitioned view?
What is sub-query in sql server?
What is view in sql?
What is inline variable assignment?
What are various ways to enhance the ssrs report?
What is 'Join' and explain its various types.
Tell me what is the significance of null value and why should we avoid permitting null values?
What is the simplest way to create a new database in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the different types of indexes?
How to send email from database?
What is attribute hierarchy? : sql server analysis services, ssas
What is a filestream?