Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between constraints and triggers?
- 9 Answers
- 36656 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
Explain aggregate functions?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How to use subqueries in the from clause in ms sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Tell about MOM Tool(Microsoft Operator Manager)?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Where can you find the error log information? : sql server database administration
What are tables in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
what is a check constraint?
How can you check the level of fragmentation on a table?
Explain cross join or cartesian product in sql?
What is the use of keyword with encryption. Create a store procedure with encryption?
How to disable stored procedure sql server?
What are the different types of sub-queries?
