Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36908 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 bcp? When does it use?
How do I get to sql server configuration manager?
How do I install only the client tools of sql server 2000?
How to round a numeric value to a specific precision?
Explain about builtinadministrator?
How do you delete a data source?
What does ss stand for sexually?
Suggest a method of joining two tables.
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What are the export options of ssrs?
What is server-level principal?
How to create a ddl trigger using "create trigger" statements?
Explain nested join?
Find first and last day of current month in sql server
What is a hint?
