Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36616 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
what purpose does the model database serve? : Sql server database administration
What is sql server profiler?
Define normalisation?
Is there any difference between primary key and unique with the not null condition?
Explain in brief about Microsoft SQL server?
Tell me something about security and sql azure?
Explain different types of lock modes in sql server 2000?
Write down the syntax and an example for create, rename and delete index?
What is the order by used for?
Explain transaction server distributed transaction?
How to rebuild the master database?
What is the difference between ddl,dml and dcl commands?
What is the library index called?
How to create an inline table-valued function?
Explain the steps to create and execute a user-defined function in the sql server?
