Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36195 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / malini paul
1.Constraint is a statement about a database that is always
true.Whereas triggers constrain what a transaction can do.
2.Constrain applies to existing data in the table and any
statement that manipulates the table.Whereas Trigger does
not apply to data loaded before the trigger was created.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to invoke a trigger on demand?
How to access the deleted record of an event?
What is resultset concur_updatable?
Can we add a cpu to sql server?
What is sql profiler. What are the default templates with it? : sql server database administration
Explain multiserver query
How do I perform an unattended install of sql server 2000?
How to connect to SQL Azure Database by using sqlcmd?
Where are full-text indexes stored?
Explain transaction server distributed transaction?
How do you handle datasets larger than 50 gb?
How can you append an identity column to a temporary table?
How to use order by with union operators in ms sql server?
What command do we use to rename a database?
What is the concept of optimization?
