What is the difference between constraints and triggers?
- 9 Answers
- 33561 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / harshad more
Constraints are great at maintaining database integrity for
database fields and relationships between database tables.
Triggers are great for checking past vs. current values and
making decisions based on that data.
In my experience, it is usually much more favorable to use
constraints when possible and leave the trickier business
and auditing logic for use in triggers.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Tell me the difference between clustered and non-clustered index?
What is the ‘fillfactor’?
What’s the distinction between dropping a info and taking a info offline?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is “asynchronous” communication in sql server service broker?
What are the drawbacks of reporting in ssrs?
Tell me what is fill factor?
How to insert multiple rows with one insert statement in ms sql server?
Working with TLogs
Where cross join is used?
Can the query output be sorted by multiple columns in ms sql server?
How you trouble shoot when any job fails
What is difference between primary key and foreign key?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
