Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36206 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
Define compound operators?
How many types of objects are there?
What are the kinds of subquery?
what is the system function to get the current user's user id? : Sql server database administration
Why SQL Agent is used?
Explain insert into select statement?
Explain use of expression builder.
How are the unique and primary key constraints different?
What is the openxml statement in sql server?
What is checkpoint process in the sql server?
What is instead of trigger sql server?
How to Sync Two SQL Azure Databases?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is acid properties?
Explain few examples of RDBMS?
