Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36545 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
What is an example of a foreign key?
What are number line correlation administrators will use while working with a subquery?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
what are isolation levels? : Sql server database administration
Tell about MOM Tool(Microsoft Operator Manager)?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the different subsets of sql?
What is index in an assignment?
what is the maximum size of a row? : Sql server database administration
What are “phantom rows”?
what are the new features introduced in sql server 2000? : Sql server database administration
How to enter binary string literals in ms sql server?
What is the name of the Database which IBM mainframe uses?
What are the different acid properties?
